Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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
User | Count |
---|---|
88 | |
72 | |
69 | |
65 | |
57 |
User | Count |
---|---|
93 | |
93 | |
91 | |
76 | |
69 |