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
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))
Solved. Thanks alot
Engage and empower students with Power BI!
Continue your learning in our online communities.
Travel to Melbourne and network with thousands of peers!