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
"Duplicate attribute key" error when attribute is not a key

I am getting the following error when processing a Dimension: Errors in the OLAP storage engine: A duplicate attribute key has been found when processing: Table: 'dbo_Orders', Column: 'Project', Value: 'client service stuff'. The attribute is 'Project'. 'Project' is …

Read More