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 ...
Thanks MFelix... I just editeed to question above... I need to base the sum levels on the relation between Child and Parent row Ids since it may change...
Hi Anonymous ,
How do you now the sorting order of the columns based on the parent child? there is an option to create a PATH function that would give you the values and each of the levels you need however when you have several values concurring at the same level how do you know the sorting?