Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I have a data model and I am trying to compare previous year unmatched to current year (Y over Y change) based on encounter_date.
I am using the following formulas to do this:
Unmatched:=CALCULATE(COUNT([ID]),FILTER(PI_Incentives_Data_Dump,PI_Incentives_Data_Dump[Payment_Amount]=0))
Unmatched Last Year:=CALCULATE([Unmatched],SAMEPERIODLASTYEAR(PI_Incentives_Data_Dump[Encounter_Date]))
Year Over Year Change:=[Unmatched]-[Unmatched Last Year]
The above works as long as I pull the encounter_date into the pivot however when I pull in the encounter_date_year (=YEAR([Encounter_Date])) it no longer works.
Any help is greatly appreciated...
Thanks
Solved! Go to Solution.
See if my Time Intelligence the Hard Way provides a different way of accomplishing what you are going for.
https://community.powerbi.com/t5/Quick-Measures-Gallery/Time-Intelligence-quot-The-Hard-Way-quot-TIT...
See if my Time Intelligence the Hard Way provides a different way of accomplishing what you are going for.
https://community.powerbi.com/t5/Quick-Measures-Gallery/Time-Intelligence-quot-The-Hard-Way-quot-TIT...
thanks Greg
User | Count |
---|---|
98 | |
90 | |
77 | |
71 | |
64 |
User | Count |
---|---|
114 | |
97 | |
95 | |
68 | |
65 |