Jan 25 2023 02:43 AM
Hi, I have recently converted a revenue table from a regular Pivot Table to Power Pivot.
It's a simple customer down the left and monthly periods across the top, which shows revenue by customer / product etc for the last 12 months.
I am now struggling to create a measure to show the variance between the current month and the previous month (month over month variance), which would show in the right hand most column (similar to what is available as a calculated field in a regular pivot table).
Any guidance please?
Thanks!
Jan 25 2023 03:03 AM
@BryanCF The site in the link below contains many helpful descriptions of all sorts of DAX patterns, including those that involve time intelligence, like month-over-month growth.