Amit Punia
Member
Hi All,
There are 2 Date Columns in my Table. I need to add a third column in this table in Power BI Desktop which will calculate the Number of Days (Not in whole number but in Decimal Data Type) between two Dates(Data Type is Date/Time) excluding Weekends (Saturdays and Sundays).
Example - If Start Date is 28th Jan, 2022 11:20:15 AM and End Date is 2nd Feb, 2022 10:12:55 AM then it should skip the Saturdays and Sunday in it but should give me anything above the whole days in decimal too. Right now I'm using below mentioned function to add the Column in my existing table.
Days Without Weekends = NETWORKDAYS(Start Date, End Date)-1
This above function is giving me output as 3.00. But I need any extra hours above 3 Days in decimals too.
Thanks in advance.
There are 2 Date Columns in my Table. I need to add a third column in this table in Power BI Desktop which will calculate the Number of Days (Not in whole number but in Decimal Data Type) between two Dates(Data Type is Date/Time) excluding Weekends (Saturdays and Sundays).
Example - If Start Date is 28th Jan, 2022 11:20:15 AM and End Date is 2nd Feb, 2022 10:12:55 AM then it should skip the Saturdays and Sunday in it but should give me anything above the whole days in decimal too. Right now I'm using below mentioned function to add the Column in my existing table.
Days Without Weekends = NETWORKDAYS(Start Date, End Date)-1
This above function is giving me output as 3.00. But I need any extra hours above 3 Days in decimals too.
Thanks in advance.