Forum Discussion

Rena's avatar
Rena
Resolver II
1 year ago
Solved

Table Help

I am making this way harder than it needs to be so I just deleted and need to start over.  Please help.   I need to convert my data into a table. That looks like this.   Sun Mon Tue Wed Th...
Need Help
  • MasonMA's avatar
    MasonMA
    1 year ago

    then you would need to follow the same logic to either create one Column with DAX like 

    HourSort = 
SWITCH(
    TRUE(),
    HourBlock = "7–8AM", 1,
    HourBlock = "8–9AM", 2,
    HourBlock = "9–10AM", 3,
    HourBlock = "10–11AM", 4,
    ...
)

    or i personally would prefer to use Add Column in Power Query to have them transformed in Power Query. 

     

MasonMA's avatar
MasonMA
Super User
1 year ago

Rena Hi, Power BI sorts alphabetically by default. if you wanted to sort them your way, you would need to create a column, say 'DaySort' column by, 

DaySort = WEEKDAY('Table'[Date], 1)

which returns 1 for Sunday to 7 for Saturday. 

then In the 'Data view', select the 'Table'[DayOfWeek]' colum, go to the ribbon and Sort by Column by using DaySort

 

Rena's avatar
Rena
Resolver II
1 year ago


MasonMA 

I got that to work, but now I need my [Hour Block] to also have a sort feature.  Is there a way to do two sort columns?

 

  • MasonMA's avatar
    MasonMA
    Super User
    1 year ago

    then you would need to follow the same logic to either create one Column with DAX like 

    HourSort = 
SWITCH(
    TRUE(),
    HourBlock = "7–8AM", 1,
    HourBlock = "8–9AM", 2,
    HourBlock = "9–10AM", 3,
    HourBlock = "10–11AM", 4,
    ...
)

    or i personally would prefer to use Add Column in Power Query to have them transformed in Power Query.