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 

You can do it in query editor by adding this two queries like below.

start date  

#date(2019, 1, 1) meta [IsParameterQuery=true, Type="Date", IsParameterQueryRequired=true]

dates

let
    dates = List.Dates(  #"start date", Duration.Days( DateTime.Date( DateTime.LocalNow() ) - #"start date" ), #duration( 1, 0, 0, 0 ) ),
    #"Converted to Table" = Table.FromList(dates, Splitter.SplitByNothing(), null, null, ExtraValues.Error),
    #"Renamed Columns" = Table.RenameColumns(#"Converted to Table",{{"Column1", "Dates"}}),
    #"Changed Type" = Table.TransformColumnTypes(#"Renamed Columns",{{"Dates", type date}}),
    #"Added Custom" = Table.AddColumn(#"Changed Type", "Custom", each Date.DayOfWeekName( [Dates] ), type text ),
    #"Filtered Rows" = Table.SelectRows(#"Added Custom", each [Custom] = "Monday" or [Custom] = "Tuesday")
in
    #"Filtered Rows"

 

Best Regards,
Mariusz

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

Please feel free to connect with me.
Mariusz Repczynski