Forum Discussion
vinothkumar1990
Helper II
Helper IICalculate Workdays for Direct query
I want to calculate workdays between today and created date which excludes Saturday and Sunday. I know we have Networkdays in DAX but it does not work for Direct query mode. Is there any way to do?
vinothkumar1990 , try move column calcultion inside the expression of measure
Power BI - Business day with and without using DAX Function NETWORKDAYS: https://www.youtube.com/watch?v=Qs03ZZXXE_c
Sumx(Table, <COlumn calc for net work days>)
1 Reply
- amitchandak
Super User
vinothkumar1990 , try move column calcultion inside the expression of measure
Power BI - Business day with and without using DAX Function NETWORKDAYS: https://www.youtube.com/watch?v=Qs03ZZXXE_c
Sumx(Table, <COlumn calc for net work days>)