cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper IV
Helper IV

Previous months sales based on filter selection

Hi Experts

 

Based on my month and year filter selection I would like to calculate the previous month values and populate them into my results table.

So if I select Jan 2020, then return back the value for Dec 2019 and so on...

 

Cannot get the Previou Mth measure to work.

I have a Sales Fact Table and a Dim Date Table.

 

https://www.dropbox.com/s/2ztvkjq4nl0012d/sample%281%29.pbix?dl=0 

 

 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted

@Cloud11 ,

 

I see you are refering the PY measure to the ACT measure. I've created a new measure:

_PY 2 = CALCULATE(SUM(FACT_SALES[Sales]),FACT_SALES[Scenario]="PY")

and edited the PY:

PY = CALCULATE([_PY 2], PREVIOUSMONTH('Calendar'[Date]))

 

and tested with a table visual, it worked.

 

I'm not familiar with this Zebra BI table, but with a table visual it worked.

 



Did I answer your question? Mark my post as a solution!

Proud to be a Super User!



View solution in original post

3 REPLIES 3
Highlighted
Super User III
Super User III

@Cloud11 ,

 

I checked your file, it looks like you don't have values as Scenario = "ACT" for 2019.



Did I answer your question? Mark my post as a solution!

Proud to be a Super User!



Highlighted

Thanks Camargos88.

 

One last question...select 2020 as a year i.have PY for 2019. They should populate. Unless you have spotted something else there too.

Highlighted

@Cloud11 ,

 

I see you are refering the PY measure to the ACT measure. I've created a new measure:

_PY 2 = CALCULATE(SUM(FACT_SALES[Sales]),FACT_SALES[Scenario]="PY")

and edited the PY:

PY = CALCULATE([_PY 2], PREVIOUSMONTH('Calendar'[Date]))

 

and tested with a table visual, it worked.

 

I'm not familiar with this Zebra BI table, but with a table visual it worked.

 



Did I answer your question? Mark my post as a solution!

Proud to be a Super User!



View solution in original post

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Community Conference

Microsoft Power Platform Communities

Check out the Winners!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors