Forum Discussion
Kopek
Helper IV
1 year agoCalculate difference between columns in the matrix
Hi, I have the following dataset: DateCategoryValue 01/01/2020 Category 1 100 01/01/2020 Category 1 2 01/01/2020 Category 2 3 01/01/2020 Category 3 56 01/01/2020 Cate...
- 1 year ago
Found a solution.
In case anyone stucked here is a good starting point: Solved: Difference instead of Total in PowerBI Matrix - Microsoft Fabric Community
Kopek
Helper IV
1 year agoso.. there is no simple solution to this ?
looks like it should not be that complicated... total is computed somehow, so why we are not ab;eto overwitte it with difference or something like this ?:(
lbendlin
Super User
1 year agoBecause as you said - you would have to add the additional measures to each of the columns (categories). You cannot "add columns to a matrix" - that's not a thing. Power BI is not Excel.