Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Calculating difference between 2 dates in calculated measure.

hi i need to make a calculated measure which will present the different between the two dates in the columns above.   any help will be helpful thank you  
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi Anonymous ,

     

    Try this code to create a measure.

     

    Datediff =
DATEDIFF (
    SELECTEDVALUE ( 'TableName'[Netflix Release Date] ),
    SELECTEDVALUE ( 'TableName'[Release Date] ),
    DAY
)

     

    It will work after you add this measure into a visual.

     

    Best Regards,
    Rico Zhou

     

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

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
3 years ago

Anonymous Try:

Column = ( [Netflix Release Date] - [Release Date] ) * 1.

Or you can use DATEDIFF

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    I need it as a measure m

    • FreemanZ's avatar
      FreemanZ
      Icon for Super User rankSuper User
      3 years ago

      Hi Anonymous 

      a bit unusual to have a measure in such cases.

      How would you like to use/present the expected visual?

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      Hi Anonymous ,

       

      Try this code to create a measure.

       

      Datediff =
DATEDIFF (
    SELECTEDVALUE ( 'TableName'[Netflix Release Date] ),
    SELECTEDVALUE ( 'TableName'[Release Date] ),
    DAY
)

       

      It will work after you add this measure into a visual.

       

      Best Regards,
      Rico Zhou

       

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