Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

DATEDIFF DAX

Hi guys, 

 

is there a formula for this?

 

DATEDIFF('day',[SCHEDULE_SHIP_DATE],TODAY())

 

Need Help

1 Reply

  • VahidDM's avatar
    VahidDM
    Super User
    4 years ago

    Hi Anonymous 

     

    the correct formula is:

    DATEDIFF(<start_date>, <end_date>, <interval>)

    https://docs.microsoft.com/en-us/dax/datediff-function-dax

    so try something like this:

     

    DATEDIFF([SCHEDULE_SHIP_DATE],TODAY(),DAY )

     

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

    Appreciate your Kudos!!