The 'next upload date' automatically

[KikiLondon]

I have working on a dashboard which has 3 key cards at the top for the end-users to have some information:

1. The last time the dashboard was refreshed 
2. The latest data available (max date in column)
3. and i want to create a card to say when will be the next data upload. 

The data uploads occur every monday and thursday. Is there a way of creating a measure or calculated column to automatically tell the end-user when the next upload will occur based on today's date? 

Thanks

[v-yadongf-msft · Accepted solution]

Hi @KikiLondon ,

Please try following DAX:

Next upload date = SWITCH( 
    TRUE(),
    WEEKDAY(TODAY(),2) = 1, TODAY()+3,
    WEEKDAY(TODAY(),2) = 2, TODAY()+2,
    WEEKDAY(TODAY(),2) = 3, TODAY()+1,
    WEEKDAY(TODAY(),2) = 4, TODAY()+4,
    WEEKDAY(TODAY(),2) = 5, TODAY()+3,
    WEEKDAY(TODAY(),2) = 6, TODAY()+2,
    WEEKDAY(TODAY(),2) = 7, TODAY()+1
)

You get the 'next upload date' automatically:

Best regards,

Yadong Fang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.