Forum Discussion
Solved
Consolidate Value Columns into One Value Column based on a condition
Hi all - I am working to transition our financial statements into PowerBI. We use Netsuite for our Income Statement Actuals reporting. The problem I am running into is that the monthly actuals a...
Hi cartergardner ,
You can try unpivotting all the separate Month columns together which would create a consolidated "Attribute" and "Value" column.
Thanks!
Avantika
Avantika-Thakur
Solution Supplier
Solution SupplierHi cartergardner ,
You can try unpivotting all the separate Month columns together which would create a consolidated "Attribute" and "Value" column.
Thanks!
Avantika
Avantika-Thakur - I'm sure it is clear that I am new to PowerBI - this is an absolute life saver. Thank you!