Calculating difference between 2 dates in calculated measure.

[Anonymous]

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

[Greg_Deckler]

@Anonymous Try:

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

Or you can use DATEDIFF

[Anonymous]

I need it as a measure m

[v-rzhou-msft · Accepted solution]

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.

[FreemanZ]

Hi @Anonymous 

a bit unusual to have a measure in such cases.

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