Forum Discussion
Solved
Help needed - measures/matrix
Hello, Please, I am looking for help with creating of matrix from general ledger (accounting). - I have some accounts used in the general ledger (data source table) where one transaction equa...
Hi, Petrx ;
You could unpivot column in power query ,then create a measure .
1. unpivot in power query.（Selected UMD and UD column then unpivot）
2. create a measure.
Measure = IF(ISINSCOPE('Table'[kind]),SUM([Kc]),SUMX(FILTER('Table',[kind]="UMD"),[Kc])-SUMX(FILTER('Table',[kind]="UD"),[Kc]))The final output is shown below:
Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Petrx
When dealing with GL(General Ledger) You need to start grouping the Accounts numbers then use DAX to sum up those accounts Debit & Credit.
Check this out