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.
Hello Power Users,
I get an automated billing feed via email for various insurance products in the following format. I was just wondering if someone can help me transform it into a table please.
Desired Output:
@stevedep @v-kelly-msft @edhans @mahoneypat @Anonymous
Solved! Go to Solution.
You can adapt the approach shown in this video to get your desired result. You will need to add a custom column for each of the fields above the table with a formula like this
= if Text.Contains([Column1], "GROUP NO") then [Column1] else null
Once you do that for each, you can use Fill Down to populate those columns, then filter out the original header rows.
(3) Power BI - Shift N Fill Data Pattern - YouTube
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
You can adapt the approach shown in this video to get your desired result. You will need to add a custom column for each of the fields above the table with a formula like this
= if Text.Contains([Column1], "GROUP NO") then [Column1] else null
Once you do that for each, you can use Fill Down to populate those columns, then filter out the original header rows.
(3) Power BI - Shift N Fill Data Pattern - YouTube
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
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.