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.
Hi all,
My cliente has a table like this:
To create measure and graph I need to identify the columns I am think to do something like this:
There will be any way to to that?
Thanks
Solved! Go to Solution.
1. Create a Custom Column to identify only the header rows (used simple Text.Contains here, but you logic may be more complicated depending on true data?)
2. Now that the new colum has our headers and 'null' everywhere else, we can FILL DOWN on the new Column
3. Finally, apply a filter to remove the header rows
Proud to give back to the community!
Thank You!
Is this imported data into PowerBI thru Power Query (where we can manipulate the data structure) or something like Direct Query where we have to do this all via Measures?
Forrest
Proud to give back to the community!
Thank You!
1. Create a Custom Column to identify only the header rows (used simple Text.Contains here, but you logic may be more complicated depending on true data?)
2. Now that the new colum has our headers and 'null' everywhere else, we can FILL DOWN on the new Column
3. Finally, apply a filter to remove the header rows
Proud to give back to the community!
Thank You!
Yes it is using power query
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 |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |