Forum Discussion
RKM
Helper IV
3 years agoSpecial Calculated Column Requirement in Matrix (PBIX Attached)
Dear PBI Experts, I am struggling with a recent requirement and not sure whether/how it can be addressed in Power BI. I tried developing my PBI as far as I could, but there is one requirement where ...
RKM
Helper IV
3 years agoNot sure if I understood that correctly, or if those are similar scenarios....
As the PBI file attached - I am struggling to add these 3 red columns. I can try calculating them with some custom measure, but then Already in my matrix there are two columns... Mode (for Cash or Credit) & Direction (Buy Or Sell). The moment I am trying to add any new column or value its getting totally messed up and repeating all columns everywhere. But again... adding more calculation on Raw will also not help because mostly all fields will be collapsed (expanded when necessary), so any new Raw attribute will be hidden,