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

Published: 09 August 2023
on channel: MilEstOne CrEaTor

43,013

929

Hey Everyone Welcome Back to my YouTube 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:- https://tinyurl.com/2jva36cu
Data Set:- https://tinyurl.com/48nt7sd7

#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, Previous & SamePe...

Power Bi Log In With Personal E-Mail ID || ( No Need Of Work/Student-Mail ID ) [ Update-2013 ]:-
   • Power Bi Log In With Personal E-Mail ...

Add POWER to your Titles & Sub_Title in Power BI I| The NEW TRICK you need to know In HINDI:-
   • Add POWER to your Titles & Sub_Title ...

New Features Of Title & Subtitle In Power Bi [ March - 2023 Update ]:-
   • New Features Of Title & Subtitle In P...

How To Update Your Power Bi Desktop To Latest Version || [👉In 2023 ]:-    • How To Update Your Power Bi Desktop T...

What's New In POWER BI-March 2023 Release🔥:-
   • What's New In POWER BI-March 2023 Rel...

📊 Complete Power Bi interview Q & A For Freshers - [ Latest 2023 ]:-
   • 📊 Complete Power Bi Interview Q & A F...

What Is DAX - Power Bi ? 📊Complete Introduction🔥:-
   • What Is DAX - Power Bi ? 📊Complete In...

DAX Interview Questions and Answers - POWER BI [ Part - 1 ]🔥:-
   • DAX Interview Questions and Answers -...

DAX Interview Questions and Answers - POWER BI [ Part - 2 ]🔥:-
   • DAX Interview Questions and Answers -...

Super 30 DAX Interview Question & Answer - POWER BI🔥:-
   • Super 30 DAX Interview Question & Ans...

Rate Yourself In DAX - POWER BI / Excel 📊:-
   • Rate Yourself In DAX - POWER BI / Exc...

Introduction To DAX:-
   • Introduction To DAX - POWER BI || [ P...

DAX Operators and Text / String Functions - Power BI:-
https://www.youtube.com/watch?v=UyWCp...

Complete Logical DAX Function In - POWER BI:-
   • Complete Logical DAX Function In - PO...

Complete Date And Time DAX Function In - POWER BI:-   • Complete Date And Time DAX Function I...

Complete Math And Statistical DAX Function In - POWER BI:-
   • Complete Math And Statistical DAX Fun...

DAX Operators and Text / String Functions - Power BI :-
   • DAX Operators and Text / String Funct...

Complete Time Intelligence DAX Function In - POWER BI:-
   • Complete Time Intelligence DAX Functi...

Complete Filter DAX Function In POWER BI :
   • Complete Filter DAX Function In -POWE...

🔔 Subscribe to my YouTube channel:-
https://www.youtube.com/channel/UCWfz...

Social Media Link
--------------------------------
Linkedin:- linkedin.com/in/deepan-kumar-patel-777591202
Facebook:-   / dipan.patel..  .

Watch video CALCULATE 📊Current, Previous & SamePeriodLastYear | MTD QTD YTD | MoM QoQ YoY In POWER BI Using DAX online without registration, duration hours minute second in high quality. This video was added by user MilEstOne CrEaTor 09 August 2023, don't forget to share it with your friends and acquaintances, it has been viewed on our site 43,01 once and liked it 92 people.