Calculate Year Over Year (YoY) Variance % 🔥| DAX | Power BI

preview_player
Показать описание
Hello Everyone Welcome back to Milestone Creator. So, today In this tutorial, I am explaining how we can Calculate Year Over Year (YoY) Variance % | DAX | Power BI.

In Power BI, we may want to compare periods with our data to create reports such as year over year comparisons. Power BI offers several DAX time intelligence functions. In this post we will look at SAMEPERIODLASTYEAR.

🚀Pbix File:-

✅QUESTION:-

How To Calculate Year over Year (YoY) Variance % In POWER BI ❓

✅Answer:-

🚀Calendar = CALENDARAUTO()
🚀Date = DATE(YEAR('Calendar'[Date Time]), MONTH('Calendar'[Date Time]), DAY('Calendar'[Date Time]))
🚀Total Revenue =
SUMX(Purchase, Purchase[Revenue])
🚀Previous Year Revenue = CALCULATE([Total Revenue],
DATEADD('Calendar'[Date],-1,YEAR))
🚀YoY Variance = [Total Revenue] - [Previous Year Revenue]
🚀YoY Variance % =
DIVIDE([YoY Variance],[Previous Year Revenue])

------------------------------------------------------------------------------
✅ Additional resources
------------------------------------------------------------------------------

#deloitte 📊TOP 10 Scenario Based POWER BI Interview Q And A🔥:-

#mindtree 🔥Scenario-Based Power BI Interview Q & A Based On Handling Blank Value To Zero:-

#tcs 📊TOP 10 Scenario Based #powerbi Interview Q And A🔥[ For Freshers/Experienced Candidate ]:-

#techmahindra 🔥Scenario-Based Power BI Interview Q & A Based On Data Source Connection Change:-

#infosys 🔥Scenario-Based Power BI Interview Q & A Based On📊Calculation Of Year Over Year (YoY %):-

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

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

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

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

Introduction To DAX:-

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

🔔 Subscribe to my YouTube channel:-

Social Media Link
--------------------------------
Рекомендации по теме
Комментарии
Автор

Excellent video I have just done some small project with your video thankyou so much.

asmashabbir
Автор

Thank you for informative video's.

krishanmandal
Автор

17:00 for negative marks revenue you should have shown in conditional formatting by giving red color for negative revenue and green color for positive revenue values

beingrishi