Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.
Hi,
I am trying to get a net working days for an aging calculation where you have a a filter date (report date). The calculation works fine when I just do the days but when I add in the business days, I get this weird error.
Basically I want at 8/1, to get an accurate calculation for working days and total days for each order created.
I have a Many to one relationship between createddate and the filter date.
Can anyone point me in the right direction?
Thanks that is really helpful. What I struggle with is that the start date could be dynamic. Someone could want to run it for 7/1 instead of 8/1 so how would I get that end date to change from 7/1 to 8/1 (while keeping the old date).
Thanks
@bcobrien1977 , You can use networkdays
measure =
calculate(networkdays(min(Table[Stare]), max(Table[End Date]), 1)
Column=
calculate(networkdays((Table[Stare]), (Table[End Date]), 1)
Power BI - Business day with and without using DAX Function NETWORKDAYS: https://www.youtube.com/watch?v=Qs03ZZXXE_c
https://medium.com/@amitchandak/power-bi-dax-function-networkdays-5c8e4aca38c
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.