Help with number of days calculation

[SteffanieJ]

Hello!

I have a formula that is calculating (columns) delivery date/time - order date/time - (measure) non-work days.  It seems to be mostly working but is slightly off from what my Excel formual is giving me.

This is my Power BI formula and results...

This is my Excel formula and results...

Can someone tell me what I am missing in Power BI that is throwing the numbers slightly off?

[Anonymous]

Hi @SteffanieJ ,

Any update on this? Can you please share some dummy data that keep the raw data structure with expected results? It should help us clarify your scenario and test to coding formula.

How to Get Your Question Answered Quickly  

Regards,

Xiaoxin Sheng

[Greg_Deckler]

@SteffanieJ Sorry, having trouble following, can you post sample data as text and expected output?
Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882

Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.