Current month sales to show under next month

DAX DAX Calculations
1

Odd request. I have a Total Revenue measure. Lets say my Total Revenue for Feb 2022 is $100. I want to build a matrix and have the $100 actually appear under March 2022. How do I do this?

I tried
Calculate([Total Revenue],
‘Date’[Date] = EOMONTH(‘Date’[Date],1))

but it didnt work

2

Add a custom column Next Month Date to your Calendar Table in Power Query and use the Date.AddMonths function to generate a date next month, then create a custom column Next Month and generate Month-Year using Date.Month and Date.Year. Use this custom column to create a matrix with Total Revenue and Next Month.

References:

1 Like