Forum Discussion
month to month calculation
hello fellows, im trying to calculate Month to month expenses change in my dataset, which inculdes one whole year data of expenses for different categories on different dates. i tried finding...
xifeng_L hello, thankyou, i created new date table for slicer, and used this measure:
Previous month =
CALCULATE([Total],PREVIOUSMONTH('2024'[Date]),ALL('date'[month]))
now im getting previous month value but shows total value for all categories and subcategories in matrix.
now im getting previous month value but shows total value for all categories and subcategories in matrix.
- xifeng_L
Super User
Need more info to judge, can you provide the pbix file?
