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,
Looking for some help with this one. I have a table with two columns, Sales Order and Invoice. Sometimes, there are multiple Invoices per Sales Order. I'd like to break the INVOICENUMBER field in the photo below out into multiple fields in the Power Query Editor, so that sales order (circled below) 3010000014 and 3010000028 will show two columns for INVOICENUMBER instead of just one (INVOICENUMBER_1, INVOICENUMBER_2, etc). These are two examples where two invoices occurred for one Sales Order, but orders can have up to 15-20 invoices generated against them sometimes. Thanks in advance for your help PBI community!
Solved! Go to Solution.
I would caution against doing this (unless you have a very good reason). Powerbi works very well with columnar data and whatever you are planning will probably be easier with data in the current format. (Just my opinion )
I would caution against doing this (unless you have a very good reason). Powerbi works very well with columnar data and whatever you are planning will probably be easier with data in the current format. (Just my opinion )
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 |