Forum Discussion

Sven's avatar
Sven
New Member
9 years ago
Solved

extract 2 dates in query editor

Hello Power BI community,

 

I am new to Power BI and want to extract 2 dates out of 2 columns in the query editor and add in to a new colomn.

When I do this I want to it like this: Date 1 - Date 2 = lead time in days, but Power BI gave an error on the operator: -. I tried to do this with the measure datediff(date.1;date.2) too, but did not work either.


Is anyone that can help me I would be very pleased!

 

Thanks in advance!

  • Sven

     

    Hi Sven

     

    Select your Columns and Go to Add Column-Date-Substract Days

     

     

     

    Or a in Custom Column

     

2 Replies

  • Vvelarde's avatar
    Vvelarde
    Community Champion

    Sven

     

    Hi Sven

     

    Select your Columns and Go to Add Column-Date-Substract Days

     

     

     

    Or a in Custom Column

     

    • Sven's avatar
      Sven
      New Member

      Thank you!!! this was what I needed!!