Forum Discussion

nnouchi's avatar
nnouchi
Helper I
7 years ago
Solved

Difference in Dates between two datetime values in different columns

Hi there,

 

I'm still somewhat new to Power BI and have been trying to find a way to calculate differences in two datetime values for two different columns in the same table. 

 

An example of these two datetime columns would be a shipping and receiving date.

 

Any help would be appreciated.

Need Help
  • PattemManohar's avatar
    PattemManohar
    7 years ago

    Try this.... by adding a new column...

     

    DaysDiff = DATEDIFF('DateDiff'[ShippingDate],'DateDiff'[ReceivedDate],DAY)

2 Replies

  • PattemManohar's avatar
    PattemManohar
    Community Champion
    7 years ago

    Try this.... by adding a new column...

     

    DaysDiff = DATEDIFF('DateDiff'[ShippingDate],'DateDiff'[ReceivedDate],DAY)

    • nnouchi's avatar
      nnouchi
      Helper I
      7 years ago

       

      Ah, I subsequently just discovered that I need to create a calculated column in the case that I use values that transcend actual measures. I appreciate your help, but my issue is resolved.

       

      Thanks