cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
SamiTi Frequent Visitor
Frequent Visitor

Previousmonth by category not working

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

CaptureTable.JPG

1 ACCEPTED SOLUTION

Accepted Solutions
pawel1 Member
Member

Re: Previousmonth by category not working

PREVIOUSMONTH will work when a single month is filtered, eg. in a slicerprevmonth.PNGtry using DATEADD function, then any period selection is possible:

 

PREVMONTH = CALCULATE([Volume],DATEADD('dim MS Cal'[Date],-1, MONTH))dateadd.PNG

2 REPLIES 2
pawel1 Member
Member

Re: Previousmonth by category not working

PREVIOUSMONTH will work when a single month is filtered, eg. in a slicerprevmonth.PNGtry using DATEADD function, then any period selection is possible:

 

PREVMONTH = CALCULATE([Volume],DATEADD('dim MS Cal'[Date],-1, MONTH))dateadd.PNG

SamiTi Frequent Visitor
Frequent Visitor

Re: Previousmonth by category not working

Solved. Thanks alot 

Helpful resources

Announcements
Back to School Contest

Back to School Contest

Engage and empower students with Power BI!

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Summit Australia 2019

Summit Australia 2019

Travel to Melbourne and network with thousands of peers!

Top Ideas
Users Online
Currently online: 116 members 1,599 guests
Please welcome our newest community members: