Forum Discussion

negbc's avatar
negbc
Icon for Helper II rankHelper II
1 year ago
Solved

Date Table Sorting and Grouping

I have a standard date table and added columns to display Quarter, Quarter-Year, and then a Date Sort Column with the dax formula: Date Sort Column = 'Date Table'[Year]*12 + 'Date Table'[Month]  ...
Need Help
GiuseppeMR's avatar
GiuseppeMR
Frequent Visitor
1 year ago

Is the date sort column used to define a custom sort of this visual?

If so, this implies that the granularity of the visual includes this dimension, even if the sort column is not visible.

 

Giuseppe

  • negbc's avatar
    negbc
    Icon for Helper II rankHelper II
    1 year ago

    Yes I use the date sort column to sort other columns such as Qtr-Year. With what you are saying, I need a calculated sort column that uses quarter instead of month. That way it will have the same granularity..

    (OLD) Date Sort Column =
    'Date Table'[Year]*12 + 'Date Table'[Month]

    (NEW)     Date Sort Column =
    'Date Table'[Year]*12 + 'Date Table'[Qtr]
     
    GiuseppeMR Thank you!