Forum Discussion

KikiLondon's avatar
KikiLondon
Regular Visitor
4 years ago
Solved

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:

  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's avatar
    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.

1 Reply

  • v-yadongf-msft's avatar
    v-yadongf-msft
    Icon for Community Support rankCommunity Support
    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.