Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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.
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.
@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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
97 | |
85 | |
68 | |
59 |
User | Count |
---|---|
150 | |
120 | |
100 | |
87 | |
68 |