Forum Discussion

NewbieJono's avatar
NewbieJono
Post Partisan
2 years ago
Solved

Last Date

My date table is set to go up to today ()   one of my data table has data up to 01/03/2024.   i want to bring back the latest score from the data table. when I use last day with the date table it...
Need Help
  • Jihwan_Kim's avatar
    Jihwan_Kim
    2 years ago

    Hi,

    I am not sure how your semantic model looks like, but please try something like below whether it suits your requirement.

     

     

     

     

    Latest - CSLatest = 
CALCULATE (
    [Score - CS],
    LASTDATE(SUMMARIZE(Data, 'Calendar'[Date]))
)

     

NewbieJono's avatar
NewbieJono
Post Partisan
2 years ago

this works but its not allowing me to use the same period last year function with it