Forum Discussion

BratKat's avatar
BratKat
Microsoft 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.  

DOLEARY85's avatar
DOLEARY85
Resident Rockstar
3 years ago

Hi,

 

any measures or columns created in report view are caclulated after the import of data and therefore will not appear in transform. What is it you're looking to do with the column in transform?

 

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍