Forum Discussion
Transform table using DAX
Hello! I am very happy to get ideas on how to transform a table from source to target below using DAX. ------------- EDIT Logic for Sum levels: Number of sum levels are 3 since number of unique ...
When you reflect that should reflect is to keep it on the same sorting ?
Again EBIT row that has a sequence of 0 if it changes to 55 should keep the sorting order of 11 correct?
Thanks for not giving up on me 🙂
If the SequenceNo of row "EBIT" changes from 0 to 55, The sorter order will change from 11 to 12 for tat particular row.
Because: The row "EBIT margin" has the sequenceno 38, which is less than 55 so that particular row the will get sort order 11 instead of 12.
Hope it is not impossible to grasp