Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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!
Solved! Go to 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
@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
Wow, that was exactly what I needed! Thank you so much! You made my day!
@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
User | Count |
---|---|
122 | |
69 | |
67 | |
58 | |
52 |
User | Count |
---|---|
187 | |
94 | |
67 | |
63 | |
54 |