Calculate MoM growth – period variance using Power BI DAX

Learn how to use Power BI 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

Contents

1. Intro – 00:00
2. Create Matrix visual – 00:40
3. Add Dates and Drill down to month – 00:51
4. Add Total Amount Measure – 01:11
5. Calculate last month amount – 02:31
6. Calculate growth percentate – 03:32
7. Format the measure – 04:42
8. Add conditional formatting – 05:06

Related videos

Pivot Table Date Tutorial: How to group Dates by Fiscal Years and Quarters using VLOOKUP

Daily opening and closing balance by product – Excel and Power BI – DAX

Everything About Conditional formatting in MS Excel

Handle millions of rows in Excel – Large slow files? – use Data Model