Forum Discussion
Aggregate sum using groupby with date filter
Hi all, I have calulated measure and refrenced it to a created table, I also created a group column in reference table to achieve following result:- But i do not get correct re...
The order in the matrix visual is off because the "Groups" column is in text type. To solve this you need to add an index column to the table in Power Query and then, once loaded, select the "Groups" column in the table view and use the "Sort column by" option in the ribbon and select the Index column.
The order in the matrix visual is off because the "Groups" column is in text type. To solve this you need to add an index column to the table in Power Query and then, once loaded, select the "Groups" column in the table view and use the "Sort column by" option in the ribbon and select the Index column.