Forum Discussion

Narasimha's avatar
Narasimha
Icon for Helper I rankHelper I
9 years ago
Solved

Week formats

Hi Team,   I want to display the visual like below Instead of below I want week starts from Monday to sunday.. How to do the same..   Thnaks in advance  
Need Help
  • GilbertQ's avatar
    GilbertQ
    9 years ago

    Hi Narasimha

     

    If you go into the Query Editor and then the Date table.

    Click on Add Column in the ribbon and then click on Custom Column, and give it a name.

    Put in the following code below.

     

    Date.ToText(Date.StartOfWeek([Calendar Date], Day.Monday),"MM/dd") & "-" & Date.ToText(Date.EndOfWeek([Calendar Date], Day.Monday),"MM/dd")

    This will then create the column you require.

Narasimha's avatar
Narasimha
Icon for Helper I rankHelper I
9 years ago

Hi GilbertQ,

 

Am getting below error while trying to create new column in Date table. Could you please help me out.

MarcelBeug's avatar
MarcelBeug
Icon for Community Champion rankCommunity Champion
9 years ago

You forgot to go into the Query Editor.

The code from GilbertQ is Power Query (M), not DAX.