Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Good day all,
This is a somewhat tricky question to articulate properly, but I will try my best. My company uses MS Excel data is that automatically generated from a server that I have no control over. In this scenario, the "Father" is the CEO and is passing that on to the "Son" who is currently the Manager. The Manager will then become the "Grandson."
For PowerBI visual purposes, I want to create new columns that combine all the data loaded under "CEO" under a new name and combines all the data of the "Manager" under a new name. Essentially the hierachy is moving but the data needs to keep displaying the same for historical purposes. Here is the example of how it would look in Excel, now how would I make it seamless in PowerBI when programming the "What We Will See" columns?
Thank you for however you can help!
@Wooticus , refer if this method can help
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
97 | |
94 | |
74 | |
71 | |
64 |
User | Count |
---|---|
143 | |
109 | |
103 | |
82 | |
74 |