Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.
Check it out now!Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers. Get Fabric certified for FREE! Learn more
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
@Anonymous , 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