Calculate MoM growth - period variance using Power BI DAX | @efficiency365
829 بار بازدید -
2 ماه پیش
-
Learn how to use
Learn how to use #powerbi #dax to calculate mom growth or decline using a measure. #analytics
We will use the PREVIOUSMONTH function to create a measure for comparison.
Download sample file
https://efficiency365.com/wp-content/...
Contents 📚
00:00 - Intro
00:40 - Create Matrix visual
00:51 - Add Dates and Drill down to month
01:11 - Add Total Amount Measure
02:31 - Calculate last month amount
03:32 - Calculate growth percentate
04:42 - Format the measure
05:06 - Add conditional formatting
Related videos 📺
Pivot Table Date Tutorial: How to group Dates by Fiscal Years and Quarters using VLOOKUP - Pivot Table Date Tutorial: How to gro...
Daily opening and closing balance by product - Excel and Power BI - DAX - Daily opening and closing balance by ...
Everything About Conditional formatting in MS Excel - Everything About Conditional formatti...
Handle millions of rows in Excel - Large slow files? - use Data Model - Handle millions of rows in Excel - La...
Buy Dr Nitin's latest book
-----------------------------------------
Efficiency Best Practices for Microsoft 365
130 best practices everyone must know
Work Smarter, Grow Faster
https://s.efficiency365.com/bk
Dr Nitin Paranjape is the pioneer in maximizing work efficiency in a modern work scenario.
Dr Nitin's Office Masterclass
----------------------------------------------
https://hi.switchy.io/mms
Online Courses by Dr Nitin Paranjape
--------------------------------------------------------------
Pivot Table Advanced - https://s.efficiency365.com/ptyt
Excel to Power BI - https://swiy.io/uxlpbi
Learn more from 1000+ blog articles by Dr Nitin Paranjape
Efficiency 365 blog: https://efficiency365.com/blog
LinkedIn : LinkedIn: nitinparanjape
Twitter : Twitter: drnitinp
Production
--------------------
Music and Effects: https://elements.envato.com/
Created using Adobe Premiere: https://www.adobe.com/in/creativeclou...
AI based captions: https://videoindexer.ai (Microsoft service)
We will use the PREVIOUSMONTH function to create a measure for comparison.
Download sample file
https://efficiency365.com/wp-content/...
Contents 📚
00:00 - Intro
00:40 - Create Matrix visual
00:51 - Add Dates and Drill down to month
01:11 - Add Total Amount Measure
02:31 - Calculate last month amount
03:32 - Calculate growth percentate
04:42 - Format the measure
05:06 - Add conditional formatting
Related videos 📺
Pivot Table Date Tutorial: How to group Dates by Fiscal Years and Quarters using VLOOKUP - Pivot Table Date Tutorial: How to gro...
Daily opening and closing balance by product - Excel and Power BI - DAX - Daily opening and closing balance by ...
Everything About Conditional formatting in MS Excel - Everything About Conditional formatti...
Handle millions of rows in Excel - Large slow files? - use Data Model - Handle millions of rows in Excel - La...
Buy Dr Nitin's latest book
-----------------------------------------
Efficiency Best Practices for Microsoft 365
130 best practices everyone must know
Work Smarter, Grow Faster
https://s.efficiency365.com/bk
Dr Nitin Paranjape is the pioneer in maximizing work efficiency in a modern work scenario.
Dr Nitin's Office Masterclass
----------------------------------------------
https://hi.switchy.io/mms
Online Courses by Dr Nitin Paranjape
--------------------------------------------------------------
Pivot Table Advanced - https://s.efficiency365.com/ptyt
Excel to Power BI - https://swiy.io/uxlpbi
Learn more from 1000+ blog articles by Dr Nitin Paranjape
Efficiency 365 blog: https://efficiency365.com/blog
LinkedIn : LinkedIn: nitinparanjape
Twitter : Twitter: drnitinp
Production
--------------------
Music and Effects: https://elements.envato.com/
Created using Adobe Premiere: https://www.adobe.com/in/creativeclou...
AI based captions: https://videoindexer.ai (Microsoft service)
2 ماه پیش
در تاریخ 1403/03/26 منتشر شده
است.
829
بـار بازدید شده