Current Month

[Anonymous]

Hello Everyone,

Is there any way that we can calculate how many Monday, tuesday remaining in current month?

For example today is 01/24/2023. So, how many Monday is remaining? in my dataset that I am working on I have data upto 01/18/2023 so I need to calculate how many Mondays are remaining in current month.

Please somebody help me with the dax for the same.

Thank you in advance

[Anonymous]

@amitchandak 

Hi, It is working. But can we calculate all Monday to Friday remaining in current month.

Like, Monday - 1, Tuesday 1, Wednesday 1 so on.. 

[amitchandak · Accepted solution]

@Anonymous , You can use measure like(or column) 

Monday = Countrows( filter(calendar(Today()+1, eomonth(today(),0)), weekday([Date],2) =1))

Tuesday = Countrows( filter(calendar(Today()+1, eomonth(today(),0)), weekday([Date],2) =2))