Forum Discussion
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...
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.
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?
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.