topic Re: Dynamic matrix table with change column at the end of table in DAX Commands and Tips

Dynamic matrix table with change column at the end of table

edmundinho — Sun, 23 Feb 2025 23:34:16 GMT

Hi there,

Is it possible to add change column at the end of dynamic matrix table without interim columns as shown in my example? I understand it's not excel but maybe there are any ways to remove these unnecessary columns? I used measure to calculate change in profit betwen oldest chosen date and newst chosen date. But when I use that measure I get lot of unnecessary stuff in the table.

Re: Dynamic matrix table with change column at the end of table

lbendlin — Mon, 24 Feb 2025 00:26:56 GMT

Yes, it is possible to rededicate the Column and Row totals to run a different calculation.

What is your expectation on the Profit change calculation when the report user chooses more than two of fewer than two values? Change from what to what?

Re: Dynamic matrix table with change column at the end of table

edmundinho — Wed, 26 Feb 2025 07:48:54 GMT

Hello,

My expectation is when user choses more than two or fewer values is to calculate difference between the oldest and the newest values.