Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
I am loading data from an excel worksheet which ha a matrix with months on columns and then one column that has multiple hierarchies in stepped format like below
I would like o convert the second column into mulitple columns according to its hierarchy. However, I do not see any option in Power BI power query to do this when importing the data. I tried to unpivot this column but that did not help.
Can someone please guide me how to achieve this.
Shah
Hi @arifshah
Can you share the pbix or excel data and also mentioned the expected output in excel form.
it would be better for us to work on exact requirement.
@arifshah , what is logic for a parent. Like
New column in Power query
if [Jan 2020] = null then [Column 2] else null
If this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
Thanks for replying. I am not sure what is your solution providing. I need to split the highlighted column according to the hierarchy. Your solution does not do that
User | Count |
---|---|
98 | |
89 | |
82 | |
71 | |
67 |
User | Count |
---|---|
114 | |
103 | |
100 | |
72 | |
64 |