Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Date issue

Hi,   Here is my issue: I am trying to get the difference between two dates (I am using a direct query view), but on PBI desktop, I don’t see my fields as date format: If anyone has any ide...
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
6 years ago

Anonymous - What happens if you do this:

 

Measure = (MAX([Closure Date]) - MAX([Creation Date])) * 1.

 

?

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Thanks, it returns -40 does it mean I use this formula?

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Hi,

      after applying the formul, i am not sure the outcome is right... if you have another idea... that will be great.

      Thanks

      Kasiop_0-1598344713391.png