Previous months sales based on filter selection

[Anonymous]

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 

[camargos88]

@Anonymous ,

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

[Anonymous]

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.

[camargos88 · Accepted solution]

@Anonymous ,

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.