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.
I have date table also with formula and relationship master table
@Anonymous
It appears you want to create a measure summing interest_income for the YTD period one year ago.
I would suggest rewriting your measure like this:
A = CALCULATE ( SUM ( 'RP_001_GIME final_net_income'[interest_income] ), DATESYTD ( SAMEPERIODLASTYEAR ( Dates[Date] ) ) )
Once defined, the value of a variable is fixed, so in your original measure, the Step1 variable stored the YTD value, and this value didn't change in the subsequent CALCULATE.
Really the only way to apply two date shifts in sequence is to nest them as I have here, and you should have the actual SUM expression as the first argument of CALCULATE.
However, I can't explain why your measure returned blanks for years earlier than 2018. Just confirming that the Year colum is from the Dates table? If that's still a problem, please post back or post a sample pbix if possible.
Regards,
Owen
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 |
---|---|
110 | |
109 | |
89 | |
76 | |
66 |
User | Count |
---|---|
125 | |
111 | |
100 | |
83 | |
71 |