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



Mariusz's avatar
Mariusz
Community Champion
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



  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Thanks Mariusz 
    This solution worked for me...