Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

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 th...
  • amitchandak's avatar
    3 years ago

    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))