Can someone help to calculate YTD,MTD,QTD, PY_YTD,PY-QTD & PY-MTD without using time intellegencedax

[Abhijit_Kaware]

Hi, 

I am trying to calculate YOY,MOM MTD,YTD , QTD, PY_YTD(Previous Year),PY_MTD(Previous Year) and PY_QTD(Previous Year) without using any time intelligence functions like totalytd,datesmtd,sameperiodlastyear,etc. Can some one please help me dax I have datekey in my all tables joined with date master,from where only I can refer the date.


Thanks in advance for help. 

[v-eachen-msft]

Hi @Abhijit_Kaware ,

You could create the single year, quarter, month columns and use EARLIER() function to get the result.

[Abhijit_Kaware]

@v-eachen-msftthanks I will try this