Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

previous same period data issue

 

I have date table also with formula and relationship master table 

Dates = CALENDAR (DATE (2014, 1, 1), DATE (2018, 12, 31))
 
But i still can't solve this issue. 
Need Help

1 Reply

  • OwenAuger's avatar
    OwenAuger
    Super User
    7 years ago

    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