Forum Discussion
Divide....
Hi LCarenzo search part Month-over-month in the link https://www.daxpatterns.com/standard-time-related-calculations/
"month is in the same column" is good 🙂
I hope this help
VAR currentMonth = [Month]
VAR currentvalue = [Value]
VAR perviousmonthvalue = CALCULATE(
MAX([Value]), FILTER(ALL('TableName'),
[Category] = EARLIER([Category],
[Month] <currentMonth
)
currentvalue - perviousmonthvalue
)