How to calculate MTD QTD YTD in Power BI DAX Tutorial (6/50)

How to Calculate Year to date (YTD) calculations in DAX / Power BI
How to calculate Quarter to date (QTD) calculations in DAX / Power BI
How to Calculate Month to date (MTD) calculations in DAX / Power BI
What is YTD, QTD, MTD
How to Calculate MTD QTD YTD in DAX / Power BI
Power BI DAX Tutorial with Examples

#powerbi #powerbidax #dax #MTD #YTD #QTD

Datasource Link

DimDate Table

Complete Playlists

BI Developer - Complete Reference - Playlist
BI Architect - Complete Reference - Playlist

[mangkhongsai]

I have been struggling for a month and this video has help me understand in a rather different way. Thank you and may your videos excel each time.

[siddheshdandagavhal]

1) MTD: TotalMTD(SUM(Sales[Quantity]), DimDate[Date].[Date]) #You can also use quick measure for this
2) YTD: TotalY TD(SUM(Sales[Quantity]), DimDate[Date].[Date])
3) QTD: TotalQTD(SUM(Sales[Quantity]), DimDate[Date].[Date])
4) YTD by financial year: YTD: TotalY TD(SUM(Sales[Quantity]), DimDate[Date].[Date], "3/31")

[kirant]

Have been reading book written by MS guy for DAX. But IMO this is the best dax content i have seeen so far.

[newlifefoundation]

most underrated channel on youtube interms of power bi learning sir you are great nobody is giving the live project keep it up a lot of love -priya

[parthibangopi]

Simple snd clean explanation. I started learning DAX. Thank you

[irfandaud]

Thank You . Excellent Video ...

+ Financial Year explanation also make this lesson interesting further...

Thank You

[manoharkulat]

Thank you for the clear explanation, keep going. You are doing great work.👍

[divyagand]

simple but powerful tips. fiscal year tip was bonus.

[AArora]

Easy to understand and good simple content. Thanks for sharing knowledge.

[mannyvillanueva]

Where do I find your video on creating date tables?

[mikeycbd]

Thank you, already subscribed to your channel. First time using MTD. Will try YTD as well. Mike - Melbourne Au.

[patlollaakhila]

Really i didn't understood this topic in past but now i got clear idea on it really thank you sir, iam clear now😊

[manishlalsah]

Thankyou sir, All doubts are cleared.

[rajs]

Thank you for the detailed explanation on the concept. I am new to PowerBI and I do have one question on this video. On the table the totals for MTD, QTD and YTD are not appearing on your chart. I followed the steps as explained but the totals are appearing, tried formatting through visuals but does not work. Could you please let me know if I have done something wrong?

[Ssinger]

U have explained everything... Can u say how to calculate WTD and previous WTD i m struggling with it.. Thanks in advance.

[shrutisharma]

It was really a well explained video thank you so much .

[jeepsiejohnsonmarinas]

Thanks for the video. But can you compute the quantity sold by MTD or YTD by Product Name or Product Category. Thank you hoping for feedback.

[shivammishra-mkjp]

Please make a video with end to end project intermediate to high level also please try to provide data set that you use while making video.

[Vaibhavsemwal-kg]

Really appreciate your efforts for the level of content for the power bi aspirants. Just a question how do you create dim date component ?.Could not find in the video.

[gaddesiva]

Separate Date table is mandatory to calculate MTD, YTD, QTD? by using fact table sales date we can cal MTD, YTD, QTD?