In Power BI desktop, I have a table that basically looks like this, which I download using an API.
From that, I want to create a table that looks like this, so that I can use it to populate the Sankey visual. There will be more metrics on it than this, but this will work as an example for my frustration. lol
The first two columns would never change. The third column would need to be based off the other table.
Currently I am manually doing this in Excel, and importing that table, but that isn't ideal.
I thought I might be able to just Enter Data as a Data Source in Power BI and somehow use a formula to point to the other table, but that was a no go. Does anyone have any suggestions on how I can make this happen?? Any help would be greatly appreciated.
Helpful resources
Power BI Monthly Update - November 2025
Check out the November 2025 Power BI update to learn about new features.
Fabric Data Days
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
FabCon Atlanta 2026
Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
