Forum Discussion

farhandsome's avatar
farhandsome
Icon for Helper I rankHelper I
6 years ago
Solved

PBI - Sorting by date in a weekly glance

Hi all,   I have some SQL DirectQuery data inputted into my PBI Desktop. The data has a date column ("mm/dd/yyyy") and some corresponding data in the subsequent columns. I wanted to get the data in...
Need Help
  • FrankAT's avatar
    FrankAT
    6 years ago

    Hi farhandsome ,

    1. Create a calculated column which holds the name of the weekday correponding to the weekday number.
    2. Select this calculated column > tab Column tools > Sort by column > weekday number (see figure)

    Sort by column

     

    Regrads FrankAT

camargos88's avatar
camargos88
Icon for Community Champion rankCommunity Champion
6 years ago

farhandsome ,

 

Have you tried to sort the named day column by the numeric day column ?

 

Ricardo