Forum Discussion
Sort column not exposed in Transform data
The MonthDayNumberYear measure or column.
10 Replies
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 👍
When the column is used in a column graph and month days are displayed, these are not in correct order even if sorted correctly in the graph, need to add sorting or format to the measure\column code above so it stays sorted. A A slicer is used to select days of the month and the measure\column is used in the graph as the X-axis.
The days start out correctly then is out of order.
Thank you
Additional info:
We already have a column that has Dates in our data set, Team Date 01 that has the dates of each item in our dataset.
This is used in the X-axis
MonthWeek = 'Work Items'[Team Date 01].[Month] & " Week " & WEEKNUM('Work Items'[Team Date 01])and Team Date 01 is used in a Slicer.
