Forum Discussion
Current Month
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 , 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))
2 Replies
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))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..