The 'next upload date' automatically

I have working on a dashboard which has 3 key cards at the top for the end-users to have some information: The last time the dashboard was refreshed The latest data available (max date in column)...

v-yadongf-msft

4 years ago

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.

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 )

Forum Discussion

The 'next upload date' automatically

Related content

Data Upload

Image upload fail

Data Upload Issue

Automatics Refresh

OneDrive - Automatic upload files