Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Partiular day's date table

How do I create a table listing dates for all Mondays/Tuesdays from a given start date till today?
Need Help
  • Mariusz's avatar
    Mariusz
    7 years ago

    Hi Anonymous 

    Or dax table version 

    datesMonAndTue = 
VAR _dates = CALENDAR( DATE( 2019, 1, 1 ), TODAY() )
VAR _result = FILTER( _dates, WEEKDAY( [Date] ) IN {2, 3} )
RETURN _result
    Best Regards,
    Mariusz

    If this post helps, then please consider Accepting it as the solution.

    Please feel free to connect with me.
    Mariusz Repczynski



evandrocunico's avatar
evandrocunico
Resolver III
7 years ago

Hi Anonymous 

 

create a table 

   calendar = CALENDAR("2018-01-01";"2021-12-31")

create a new column to calendar
  dayofweek = if(WEEKDAY('calendar'[Date];2)=1||WEEKDAY('calendar'[Date];2)=2;1;0)
 
create a measure
total days = sum(dayofweek)
 
 
regards