SQLDAXExcelPython
Leaderboard
Ranking and table queriesMedium20 points

Query: label products by price

Write a DAX query that returns each Products[ProductName] and a band: Premium when UnitPrice is at least 20000, Standard when it is at least 2000, otherwise Budget.

Show solutionLifetime

Runs in your browser. The open-source dax-sql compiler turns DAX into SQL, so this isn't Microsoft's engine. The questions here were checked against Power BI Desktop, but free-form queries can occasionally differ.

DAX query
Loading editor…

Press Ctrl+Enter or Run to see the result here.