Dynamic Matrix Table

Anonymous — Thu, 04 May 2023 06:18:47 GMT

Hi All, need help on creating a dynamic matrix table.

That will allow the user to have flexibility, in selecting the columns based on a Slicer. See below for the expected output:

The section of measures is computed based on "Actual", "Plan" and "Forecast" which can be dynamically selected on the slicer.

it should also allow the user to dynamically select a period, like if they select Month, that would allow them to select 2 different month, same goes with Year, Half Year and Quarter.

Thank you so much, I am so stuck on how to create this. Any help is much appreciated.

Re: Dynamic Matrix Table

Mahesh0016 — Thu, 04 May 2023 10:20:09 GMT

Anonymous Please refer this link https://youtu.be/2y2VP6i8S8c
i hope this helps you.

topic Re: Dynamic Matrix Table in DAX Commands and Tips

Dynamic Matrix Table

Re: Dynamic Matrix Table