Forum Discussion
v4anand18
Advocate I
Advocate IBiz Days in a month calculation
Hello friends, I am new to Power BI. I need help in calculating the "Number of Business Days in a Month" and "Business Days Passed in a Month" as a measure. I tried the below formula for "Biz ...
v4anand18,
What field would you like to drag to the visual with the measure? You can use DAX below to calculate "Number of Business Days in a Month" measure, when you drag Month and this measure to a table visual, the measure should return your expected result.Number of Business Days in a Month = SUM('Business Days 2018'[IS BusinessDay])
Regards,
Lydia
v4anand18,
What field would you like to drag to the visual with the measure? You can use DAX below to calculate "Number of Business Days in a Month" measure, when you drag Month and this measure to a table visual, the measure should return your expected result.
Number of Business Days in a Month = SUM('Business Days 2018'[IS BusinessDay])
Regards,
Lydia
v4anand18Advocate I
Advocate IThanks Lydia. I used the DAX formula you posted.
It works.