Forum Discussion
Creating Columns with DAX Formulas
The first screenshot below is my Power BI Report.
The second is its list of tables, with Account Category derived from the Chart of Accounts table.
I need help with DAX, for creating columns in a new Visualization.
I want a column showing the Account Category of "Income" and another column showing "Cost of Goods Sold".
Then, I want separate columns pertaining to Dimension_Value_Code showing "ADM", "LARGE", "MEDIUM", "PROD", "SALES", "SERVICE", and "SMALL".
Also, I want two additional columns pertaining to "Amount" with the amounts pertaining to Income in one column and those pertaining to Cost of Goods Sold in another.
Finally, I need a Gross Margin column subtracting each amount of Cost of Goods Sold from each amount of Income.
What DAX fomulas can I use to create these columns?
Thanks!
John
First, please make a good data example for all involved tables with the forum table function. In the moment it its difficult to find the right columns from the tables .In general you can create a column with a measure in your matrix: E.g.
Amount of Income = sumx(FILTER(G_LEntries,Related(Chart of Account[Account Category])="Income")),G_LEntries[Amount])
2 Replies
First, please make a good data example for all involved tables with the forum table function. In the moment it its difficult to find the right columns from the tables .In general you can create a column with a measure in your matrix: E.g.
Amount of Income = sumx(FILTER(G_LEntries,Related(Chart of Account[Account Category])="Income")),G_LEntries[Amount])