Forum Discussion

mail2vjj's avatar
mail2vjj
Helper III
8 years ago

Date Difference between two random dates

Hi everyone,   I am trying to calculate the difference between two random dates.   I have a table with 2 columns 'buying dates' and 'selling dates' and another table with the Calendar on it.   ...
Need Help
Show and Tell
Tips and Tricks
v-jianhe-msft's avatar
v-jianhe-msft
Resolver II
8 years ago

Hi,

 

Thank you for the notification.

 

BR,

Henry 

 

mail2vjj's avatar
mail2vjj
Helper III
8 years ago

Hey Henry,

 

I tried your method but it doesn't seem to be working.

 

From whatever I know about PowerBI and DAX, your solution should have worked.

 

Here is the screen shot of my result.

 

 

Also, I am looking for a scalar value, not really planning to use this measure as a column in any of the tables.

 

I am still working on it and will let you know if I come up with a solution.

 

Anyways, thanks for your help and my apologies for not being able to reply sooner.

 

Thank you,

 

Vishesh Jain

  • v-jianhe-msft's avatar
    v-jianhe-msft
    Resolver II
    8 years ago

    Hi,

     

    Thank you for your notification.