Forum Discussion

Lexi's avatar
Lexi
Frequent Visitor
6 years ago

Time measures excluding weekends

Hello Power BI experts!   I am looking for help on some time calculations. I am fairly new to Power bi so would need step to step guide (teaching a baby to walk👶) Date table below:   Scenario 1:...
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi Lexi ,

 

Check these solutions for time difference

 

https://poszytek.eu/en/microsoft-en/office-365-en/powerbi-en/powerbi-datediff-only-working-days-hours-and-so-on/

https://community.powerbi.com/t5/Desktop/Calculating-Working-hours/m-p/374255/highlight/true

https://community.powerbi.com/t5/Desktop/Time-difference-between-two-date-times-excluding-weekends-and/td-p/563564

https://community.powerbi.com/t5/Desktop/Calculating-Working-Hours-Between-Two-Dates-Times/td-p/730197

https://www.youtube.com/watch?v=bs3yzmf9elA

https://www.youtube.com/watch?v=GLIoDbOiJgw

https://community.powerbi.com/t5/Desktop/DATEDIFF-Working-Days/td-p/130662

 

Regards,

Harsh Nathani

Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)