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,

 

May I know how is your issue going currently?

 

BR,

Henry 

 

mail2vjj's avatar
mail2vjj
Helper III
8 years ago

Hi Henry,

 

Sorry I didn't get a change to look at your solution.


I am still working on it and will let you know if your solution works, or if I find one of my own.

 

Thank you,

 

Vishesh Jain

  • 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.