Partiular day's date table

[Anonymous]

How do I create a table listing dates for all Mondays/Tuesdays from a given start date till today?

[Mariusz · Accepted solution]

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.

[Anonymous]

Thanks @Mariusz 
This solution worked for me...

[Mariusz]

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.

[evandrocunico]

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