Forum Discussion

amgelain's avatar
amgelain
Regular Visitor
2 years ago
Solved

DATEDIFF

Hello,   In the table there is column A with the start date and column B with the end date. When creating a measure in dax starting with DATEDIFF to find the difference between dates, these do not ...
DATEDIFF
  • Jihwan_Kim's avatar
    Jihwan_Kim
    2 years ago

    Hi, 

    One of ways to achieve this is using SELECTEDVALUE DAX function.
    Please check the below picture and the attached pbix file.

    Also, link down below is very helpful.

    Link: SELECTEDVALUE function - DAX | Microsoft Learn

     

    expected result measure: =
DATEDIFF ( SELECTEDVALUE ( Data[Date1] ), SELECTEDVALUE ( Data[Date2] ), DAY )

     

Jihwan_Kim's avatar
Jihwan_Kim
Icon for Super User rankSuper User
2 years ago

Hi, 

One of ways to achieve this is using SELECTEDVALUE DAX function.
Please check the below picture and the attached pbix file.

Also, link down below is very helpful.

Link: SELECTEDVALUE function - DAX | Microsoft Learn

 

expected result measure: =
DATEDIFF ( SELECTEDVALUE ( Data[Date1] ), SELECTEDVALUE ( Data[Date2] ), DAY )

 

amgelain's avatar
amgelain
Regular Visitor
2 years ago

Hello,

It worked out! thank you very much.