Forum Discussion

BratKat's avatar
BratKat
Icon for Microsoft Employee rankMicrosoft Employee
3 years ago
Solved

Sort column not exposed in Transform data

Have a column measure that is not exposed in Transform, is there and FORMAT command I can use in this to make sure it sorts correctly, tried other suggustions using Tooltips but those do not work. T...
  • tamerj1's avatar
    tamerj1
    3 years ago

    Hi BratKat 

    You ca create a sort by column 

    MonthDayNumber =
    VALUE (
    MONTH ( 'Work Items'[Team Date 01] ) & DAY ( 'Work Items'[Team Date 01] )
    )

    Select the MonthDay column, go to column format - sort by column and select the MonthDayNumber column. 

  • BratKat's avatar
    BratKat
    3 years ago

    The MonthDayNumberYear measure or column.  

BratKat's avatar
BratKat
Icon for Microsoft Employee rankMicrosoft Employee
3 years ago

The MonthDayNumberYear measure or column.  

BratKat's avatar
BratKat
Icon for Microsoft Employee rankMicrosoft Employee
3 years ago

Got this working, forgot to add "Year" in the data item, so now it sorts correctly, thank you.