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 ...
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])
Thank you! That worked perfectly!
John