Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Date Calculations

Hi, all

 

I want to print out the date of Monday like below.

but I don't know how to use dax function or M query.

I want someone to give me an idea.

 

 

Thanks

Need Help
  • PC2790's avatar
    PC2790
    4 years ago

    In Power Query you cna use,

    ColumnName = Table.AddColumn(Table, "WeekStarting", each Date.StartOfWeek([Date],Day.Monday), type date)

    And in Dax try using:

    Week Starting Date = Data[Date] – WEEKDAY(Data[Date],2) + 1

1 Reply

  • PC2790's avatar
    PC2790
    Community Champion
    4 years ago

    In Power Query you cna use,

    ColumnName = Table.AddColumn(Table, "WeekStarting", each Date.StartOfWeek([Date],Day.Monday), type date)

    And in Dax try using:

    Week Starting Date = Data[Date] – WEEKDAY(Data[Date],2) + 1