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.
Go to Solution.
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.
Proud to be a Super User!
View solution in original post
I checked your file, it looks like you don't have values as Scenario = "ACT" for 2019.
One last question...select 2020 as a year i.have PY for 2019. They should populate. Unless you have spotted something else there too.
Check out the on demand sessions that are available now!
Check out the Winners!
Features releasing from October 2020 through March 2021