Calculating WTD , MTD, QTD

Question

HI All,I have a Very unique req&nbsp;&nbsp;I have a column call Version&nbsp; column has 3 rows&nbsp;&nbsp;Verison&nbsp; &nbsp; &nbsp; &nbsp;Value&nbsp; &nbsp; &nbsp; &nbsp;DateActual&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1211&nbsp; &nbsp; &nbsp; &nbsp;Jan 10 2018Forecast&nbsp; &nbsp; &nbsp; &nbsp; 1221&nbsp; &nbsp; &nbsp; &nbsp;Jan 10 2018Variance&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 10&nbsp; &nbsp; &nbsp; &nbsp; Jan 10 2018.....&nbsp;This 3 rows of values are there for every day&nbsp;&nbsp;Now the problem I have is&nbsp;&nbsp;I have to calculate WTD, MTD,&nbsp;QTD&nbsp; &nbsp;values for this separately.&nbsp;Like the report I have should be displayed as below&nbsp;&nbsp;&nbsp;Version&nbsp; &nbsp; &nbsp; &nbsp; WTD&nbsp; &nbsp; &nbsp; MTD&nbsp; &nbsp; QTDActual&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; XXX&nbsp; &nbsp; &nbsp; &nbsp; XXX&nbsp; &nbsp; &nbsp;XXXForecast&nbsp; &nbsp; &nbsp; XXX&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;XXX&nbsp; &nbsp; &nbsp;XXXVarience&nbsp; &nbsp; &nbsp; &nbsp; XX&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; XX&nbsp; &nbsp; &nbsp; XX&nbsp;&nbsp;Help me to achieve this&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;

greg_deckler · Answer

Have a look at my Quick Measures here:&nbsp;https://community.powerbi.com/t5/Quick-Measures-Gallery/First-Last-Working-Days/m-p/391545&nbsp;These are working days but can easily be modified for first/last day for week, month, quarter. Once you have that, you can use those to calculate the WTD, MTD, QTD.

jjl1990 · Answer

hi&nbsp;anilp&nbsp;,&nbsp;Did you end up working this out? I have the same question

anonymous · Answer

JJL1990&nbsp; yes I made it work in the data virtualization layer so that before importing the data in to PBI, so the impact of calculations on the performance is less.

Forum Discussion

Calculating WTD , MTD, QTD

3 Replies

Related content

Calculating MTD

WTD MTD YTD table

Previous Month's MTD calculation

How to filter by YTD, MTD, WTD

MTD calculation