CALCULATE 📊Current, Previous & SamePeriodLastYear | MTD QTD YTD | MoM QoQ YoY In POWER BI Using DAX

Hey Everyone Welcome Back to my KZbin Channel "Milestone Creator".
So, today in this video we are going to see how we can calculate:-
Current Month To Date,Current Quarter To Date,Current Year To Date,Previous Month sales,previous quarter sales,Previous Year Sales,Previous Month To Date,Previous Quarter To Date,Previous Year To Date,Same perios last month,Same period Last Year,Same Period Last quarter,Month On Month,Year On Year,Quarter On Quarter,Current, Previous & SamePeriodLastYear | MTD QTD YTD | MoM QoQ YoY POWER BI
Using Time Intelligence DAX Functions
Pbix File:- tinyurl.com/2j...
Data Set:- tinyurl.com/48...
#DAX #powerbi
✅Total_Sales = CALCULATE(sum(Orders[Sales]))
✅Current MTD = CALCULATE(TOTALMTD([Total_Sales],DATESMTD(Orders[Order Date])))
✅Current QTD = CALCULATE(TOTALQTD([Total_Sales],DATESQTD(Orders[Order Date])))
✅Current YTD = CALCULATE(TOTALYTD([Total_Sales],DATESYTD(Orders[Order Date])))
✅Previous Month Total Sales = CALCULATE([Total_Sales],PREVIOUSMONTH(DATESMTD(Orders[Order Date])))
✅Previous Quarter Total Sales = CALCULATE([Total_Sales],PREVIOUSQUARTER(DATESQTD(Orders[Order Date])))
✅Previous Year Total Sales = ✅CALCULATE([Total_Sales],PREVIOUSYEAR(DATESYTD(Orders[Order Date])))
✅Previous MTD = ([Previous Month Total Sales] + [Current MTD])
✅Previous QTD = ([Previous Quarter Total Sales]+[Current QTD])
✅Previous YTD = ([Previous Year Total Sales]+[Current YTD])
✅SPLY MTD = CALCULATE([Current MTD],SAMEPERIODLASTYEAR(Orders[Order Date]))
✅SPLY QTD = CALCULATE([Current QTD],SAMEPERIODLASTYEAR(Orders[Order Date]))
✅SPLY YTD = CALCULATE([Current YTD],SAMEPERIODLASTYEAR(Orders[Order Date]))
------------------------------------------------------------------------------
👋 Additional resources
------------------------------------------------------------------------------
Time Intelligence DAX | Current, Previous & SamePeriodLastYear | MTD QTD YTD | MoM QoQ YoY POWER BI:-
• CALCULATE 📊Current, Pr...
Power Bi Log In With Personal E-Mail ID || ( No Need Of Work/Student-Mail ID ) [ Update-2013 ]:-
• Power Bi Log In With P...
Add POWER to your Titles & Sub_Title in Power BI I| The NEW TRICK you need to know In HINDI:-
• Add POWER to your Titl...
New Features Of Title & Subtitle In Power Bi [ March - 2023 Update ]:-
• New Features Of Title ...
How To Update Your Power Bi Desktop To Latest Version || [👉In 2023 ]:- • How To Update Your Pow...
What's New In POWER BI-March 2023 Release🔥:-
• What's New In POWER BI...
📊 Complete Power Bi interview Q & A For Freshers - [ Latest 2023 ]:-
• 📊 Complete Power Bi In...
What Is DAX - Power Bi ? 📊Complete Introduction🔥:-
• What Is DAX - Power Bi...
DAX Interview Questions and Answers - POWER BI [ Part - 1 ]🔥:-
• DAX Interview Question...
DAX Interview Questions and Answers - POWER BI [ Part - 2 ]🔥:-
• DAX Interview Question...
Super 30 DAX Interview Question & Answer - POWER BI🔥:-
• Super 30 DAX Interview...
Rate Yourself In DAX - POWER BI / Excel 📊:-
• Rate Yourself In DAX -...
Introduction To DAX:-
• Introduction To DAX - ...
DAX Operators and Text / String Functions - Power BI:-
www.youtube.co....
Complete Logical DAX Function In - POWER BI:-
• Complete Logical DAX F...
Complete Date And Time DAX Function In - POWER BI:- • Complete Date And Time...
Complete Math And Statistical DAX Function In - POWER BI:-
• Complete Math And Stat...
DAX Operators and Text / String Functions - Power BI :-
• DAX Operators and Text...
Complete Time Intelligence DAX Function In - POWER BI:-
• Complete Time Intellig...
Complete Filter DAX Function In POWER BI :
• Complete Filter DAX Fu...
🔔 Subscribe to my KZbin channel:-
www.youtube.co....
Social Media Link
--------------------------------
Linkedin:- linkedin.com/in/deepan-kumar-patel-777591202
Facebook:- / dipan.patel.. .

[@jodeleon8]

Just a suggestion. It would be better using the following sintaxis, for instance: SPLY QTD = CALCULATE( [Current QTD], SAMEPERIODLASTYEAR(DATESYTD(Orders[Order Date].[Date])) ) Is better because it wont generate an error when apply a page filter by category or some other dimension in your model

[@amitsundriyal1917]

Bro maza aa gaya,.... Bhut pareshan tha is DAX k liye.... Thank you bro

[@surabhijagadish5210]

A million thanks for this video. Clearly understood all concepts without any doubt.

[@surbhirautaray6872]

Thank you so much for this level of clarity.

[@bklw-g4i]

thank you, your video helps me

[@ahtishammasood1680]

Informative in simple manners. Thanks

[@mktulsani]

Simply Great 👍 Very Helpful

[@pankajkishore2257]

Awesome bhai nice explanation 🎉

[@SandipanSarkar-c8v]

Finished watching

[@vitthalchavan7578]

Excellent explanation of time intelligence dax function in PB

[@Gagan_Sky]

What would be the dax previous QTD - means if today I am in Q3 from July 1 2023 to Aug 18 2023. So what would be the output for previous QTD means for Q2 from Apr 1 2023 till May 18 2023.

[@adhipkumarnaik2167]

Thanks for this video. It's really really helpful one. "Love to Milestone Creator"❤

[@Chetan_15]

very very help full need more videos on imp interview question as exp for 2 to 3 years

[@Saiyad-s2q]

Thank you

[@mtad-health]

Very nice, it's great, thanks

[@user-pd4kq6jy3r]

great tutorial, keep up the good work

[@chalanatyjostna2229]

Hi I have a question. I am confused calculating pytd value. can you tell me which is correct between the below two to calculate PYTD avg price. should we use just the avg_price or calculated YTD avg_price? PTYD Avg Price = CALCULATE([YTD Avg Price],SAMEPERIODLASTYEAR(Calender[Date].[Date])) or PTYD Avg Price = CALCULATE([ Avg Price],SAMEPERIODLASTYEAR(Calender[Date] .[Date]))

[@muhammadtaqee9268]

👍👍👍 very good

[@RFA8280]

Sir, Very nice video but the concept for previous month/quarter to date is wrong.PMTD - Previous month to date is the period starting from the beginning of last calendar month and ending at the current day of last month. Please correct in video so that other people learning will get right logic.

[@NithinKG-h7e]

Very nice explanation

[@binapanipatel5409]

Informative video.

[@manjunatharalikatti2202]

Nice .. informative post! It will be more interesting if you can explain quarters start not on January, restrict the day from slicer for example am on 12th Aug 2023 MTD will show from 01Aug to 12th Aug 2023, I want to see current MTD from 01Aug2023 to 11thAug2023.

[@nikhil09090]

MTD = CALCULATE( [Total Sales], FILTER( ALL(Orders[Order Date]), Orders[Order Date] >= DATE(2023, 8, 1) && Orders[Order Date]

[@manjunatharalikatti2202]

@@nikhil09090 Thanks for response, Keep sharing knowledge.. Its really nice to watch your videos, knowledge full !.

[@shitalpisolkar5176]

Very nicely explained

[@prathmeshwavhal8767]

Nice, But i required Indian calendar year formula

[@Resh_Aadil_AllaboutExperience]

Great content bro👏👍

[@lifeandliving7861]

Nice

[@AshishAnand-ry1kt]

ye kpi card mein kaise show karein.....sply and cmtd mein comparison ?

[@yogeshbalwani6442]

How do i calculate these metrics when the calendar is not standard . For example fiscal year starts from 1 feb and ends on 31 Jan

[@pmohantymohanty7]

Did you check the file link you have uploaded? is it okay?

[@RCtalks186]

Bro im using MTD sales and qtd sales different measures but value is same bro anything wrong in calculation

[@ChitrakshiSaxena]

In the dataset sales column, from order id 260 to 365 instead of sales data, there is date.

[@nirajpatel2020]

👍👍👍

[@shaikakil7957]

Why we have to take New Table while creating Date In Dax ?

[@anandreddy2992]

What if the date column is having duplicate dates, datesytd is not accepting, how to handle this?

[@VandanaTiwari-t9h]

HOW TO Create a line and clustered chart and compare this year vs last year's sales along with growth % ?

[@mrsecular238]

Create a measure for variance= total sales this year - total sales last year. Now take dual axis graph, x axis give date, y axis give total sales this year and total sales last year, for line y axis give the variance created.

[@arowwman]

How to create weeky sales

[@user-rc2uc1kv6w]

please give the dataset again which wont contain error, i am noob to power bi

[@prathameshmane333]

Bhai Previous Date kaa batade..

[@neerajghansla6062]

hi your LastYearYTD period is wrong.. LastYearYTD means till date ie. 2022-01-01 to 2022-08-03.

[@debabrataroy1777]

Data of current month must be filled up to get correct output in SPLY MTD, SPLY QTD & SPLY YTD.

[@debabrataroy1777]

SPLY MTD, QTD & YTD data mismatching. Data must be taken up to August 4 of 2022, instead taking data of whole August month.

[@bslacrimosa]

Was he switching languages mid sentence?

[@user-rc2uc1kv6w]

error while loading dataset some error in the table

[@Indian-lifestyle-vlogs]

Bhai sb formula glt ho rha hai aapka ... Without filter koi answer nhi AA raha hai... Ek fir se check kro aap.. aapa data set ko increase kr k dekho koi formula kaam nhi krega... Please help kre agr time to ho fir se isi ka part 2 bnaye

[@Potter362]

Please say till date bro😉

[@pranavsharma9328]

queries not working

[@omkarrahate3488]

DATESMTD(Order[Date]) as the second parameter is unnecessary and redundant because TotalMTD alone would give you the MTD calculation.You guys are just copying each other on KZbin video and posting without making any sense. I think you guys are "ANPAD"

[@darshanchaudhari7969]

You have used wrong method complicated dax

[@milestonecreator2545]

If you think you have a better idea than this then definitely you can share that in the comment section. So that others can also benefit from that sir. Thanks for your comment. I will appreciate your New method.