Forum Discussion
hcvb07
6 years agoFrequent Visitor
Calculating Business Days without Calendar or Table Editing
Hi all! Fairly new to Power BI and hoping someone can help me out. I've been looking through some suggestions but I can't find any articles that help. I'm trying to calculate Business Days (AKA...
amitchandak
Super User
6 years agohcvb07 , refer this file I have calculated working date diff , between two date using date table
https://www.dropbox.com/s/y47ah38sr157l7t/Order_delivery_date_diff.pbix?dl=0
hcvb07
6 years agoFrequent Visitor
Thanks for the attachment! Based on my data, I can only use Ways 3 or 4 (I can't make calculated columns because I have a live connection). However, both of those still result in calendar days not business days.