No QUARTER() in DAX? Really?

ssas business-intelligence powerbi dax ssas-tabular
erop picture erop · Sep 8, 2015 · Viewed 16k times · Source

While building a Calendar table with PowerQuery for a PowerPivot model in Excel 2013 I use its Date.QuarterOfYear function to get the number of the quarter.

Building the same thing in SSAS Tabular requires some workarounds. There's no equivalent DAX function to get number of the quarter from a DATE. Strangely, DAX has YEAR() and MONTH(), but no QUARTER().

Are nested IF or SWITCH statements really the only way in DAX to get the quarter number?

What is the reason for the absence such a simple and useful function? Am I overlooking the supreme wisdom of this decision?

Answer

erop picture erop · Sep 15, 2015

I found an answer in this great book!

One should use =ROUNDUP(MONTH([Date])/3, 0) to get quarter number.

Related questions

Pentaho vs Microsoft BI Stack

My company is heavily invested in the MS BI Stack (SQL Server Reporting Services, -Analysis Services and -Integration Services), but I want to have a look at what the seemingly most talked about open-source alternative Pentaho is like. I've installed …

Read More
Sql Server Services - Overview anyone?

In Short I am thoroughly confused by the array of SQL Server services available, and am having a hard time finding a brief primer. The Scoop I am a long time ASP.Net developer who has happily been churning out …

Read More
Cant connect to analysis services via excel

I have an analysis services cube in SQL server 2005 which I'm connecting to via an excel front end. When I connect via one user its fine, but when I log on to the same machine as another user I get …

Read More