Forum Discussion
Solved
Calculate 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>)
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>)