Report Portal

DAX : Some DAX QTD, YTD and LY calculations with a Period Dimension

Sometimes, there are workbooks where you don't have a granularity on a daily basis available but on a higher level. For, instance on a weekly or a monthly level. The problem is that the normal time intelligence function only works on a date dimension on a day granularity) and not a higher level of granularity. In this blog post I'll write down some of the time intelligence based on a monthly basis period dimension. The key of this dimension is based on the format YYYYMM.

 

Read more...

 

Tags: dax, tabular

 

2007-2015 VidasSoft Systems Inc.