Display the last 12 weeks date from a selected date

[ammarzainal_94]

Hi everyone , I am trying to display the last 12 weeks date from a selected date . 
However, there are no data on the last 12 weeks date , But i just want to display the date so that viewer can take note on the last 12 weeks date . 

I am using "The Last 12 Weeks Date = CALCULATE(DATEADD(LASTDATE('Date'[Notification Date]),-77,DAY))" , but at some point , the "card" visual is showing blank because I have no notification on the last 12 weeks date from a selected date . 

Should I add another independent table to help display available date ?

Picture showing blank because there's no data on that last 12 weeks date from a selected date from the notification date filter.

Picture showing 5/23/2023 because there's a data on that last 12 weeks date from a selected date from the notification date filter.

[danextian · Accepted solution]

Why not just show in your measure what is the latest available date instead?

MESURE_ =
VAR LatestNotificationDate =
    "Latest avaiable from past 12 weeks: "
        & FORMAT (
            CALCULATE (
                MAX ( Notification[Date] ),
                FILTER ( Dates, Dates[Date] <= MAX ( Dates[Date] ) - ( 7 * 12 ) )
            ),
            "dd/mm/yyyy"
        )
RETURN
    IF ( ISBLANK ( [My Measure] ), LatestNotificationDate, [My Measure] )

[Ritaf1983]

Hi @ammarzainal_94 

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
Please show the expected outcome based on the sample data you provided.

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

[ammarzainal_94]

thanks so much @Ritaf1983  , I have the solution from @danextian working for me already . Love the community ! all of them are really kind to help .