Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi
When am using chart or table with month Previousmonth function is working well.
However when i slide this by store/category its blank.
PREVMONTH = CALCULATE([Volume],PREVIOUSMONTH('dim MS Cal'[Date]))
Appreciate your help or advise
Thanks
Sami
Solved! Go to Solution.
PREVIOUSMONTH will work when a single month is filtered, eg. in a slicertry using DATEADD function, then any period selection is possible:
PREVMONTH = CALCULATE([Volume],DATEADD('dim MS Cal'[Date],-1, MONTH))
PREVIOUSMONTH will work when a single month is filtered, eg. in a slicertry using DATEADD function, then any period selection is possible:
PREVMONTH = CALCULATE([Volume],DATEADD('dim MS Cal'[Date],-1, MONTH))
Solved. Thanks alot