If + duration calculation issue in query editor

[key_to]

Hello!

Does someone have an experience combining if statment with duration in query editor? 

I am trying to calculate the lenght of employment, my formula looks like this:

#"Inserted Duration"= Table.AddColumn(#"Added Conditional Column3", "Duration", each if [Employee Status] = "Terminated" then Date.From([Employment Details Termination Date] - [Employment Details Start Date], type duration) else each Date.From(DateTime.LocalNow() - [Employment Details Start Date], type duration)),

My formula is probably completely wrong since the only result I get is "Error". 

Appreciate any feedback! 

Thank you! 

[SpartaBI]

@key_to my pleasure :))
Listen, check out my showcase report - got some high level stuff there. Sure you will find there a lot of cool ideas. Please give it a thumbs up over there if you liked it 🙂
https://community.powerbi.com/t5/Data-Stories-Gallery/SpartaBI-Feat-Contoso-100K/td-p/2449543

[key_to]

Wow, that was exactly what I needed! Thank you so much! You made my day! 

[SpartaBI · Accepted solution]

@key_to Here is a link to download the file with a sample solution:

If + duration calculation issue in query editor 2022-08-02.pbix

      

Showcase Report – Contoso By SpartaBI