Hey,
thanks for taking the time to prepare the pbix file. I'm not able to recreate the calculated columns I posted in my initial answer - this is so weird.
Nevertheless - here you will find a working solution where the DAX statement of the calculated columns is slightly adjusted:
Business Days passed =
var currentDate = 'Calendar'[Date]
var firstdayofmonth = EOMONTH(currentDate, -1)+1
var daterange = DATESBETWEEN('Calendar'[Date], firstdayofmonth, currentDate)
return
//countrows(daterange)
CALCULATE(
SUM('Calendar'[Is Business Day])
,All('Calendar')
,daterange
)and
Business Days per Month =
var currentDate = 'Calendar'[Date]
var firstdayofmonth = EOMONTH(currentDate, -1)+1
var lastdayofmonth = EOMONTH(currentDate, 0)
var daterange = DATESBETWEEN('Calendar'[Date], firstdayofmonth, lastdayofmonth)
return
CALCULATE(
SUM('Calendar'[Is Business Day])
,All('Calendar')
,daterange
)Thanks for your patience and pointing me to an issue in my solution
Regards
Did I answer your question? Mark my post as a solution, this will help others!
Proud to be a Super User!
I accept Kudos 😉
Hamburg, Germany
