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



4 Replies

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

     

  • 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...