Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Frequent Visitor

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


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. 

Community Support
Community Support

Hi @Abhijit_Kaware ,


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



Community Support Team _ Eads
If this post helps, then please consider Accept it as the solution to help the other members find it.

@v-eachen-msftthanks I will try this

Helpful resources

PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors