Forum Discussion

Anonymous

Not applicable

5 years ago

Solved

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

camargos88
5 years ago
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.

3 Replies

camargos88
Community Champion
5 years ago
Anonymous ,

I checked your file, it looks like you don't have values as Scenario = "ACT" for 2019.
- Anonymous
  Not applicable
  5 years ago
  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
    Community Champion
    5 years ago
    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.