Dynamic columns to summarize in Power BI

[Melbourne]

Below is the sample data i have: 

 I have two date parameters which the user will select dynamically. Let say they select 2024-07-01 and 2024-10-30. i would need the values summarized for the months selected July-Oct in this case 

and eventually summarized

[Bmejia · Accepted solution]

If your data that your bringing in actually looks like the sample above you will need to first pivot the data.

Go to Transform Data select your table 

Then we are going to pivot the data so that the months are all in one column not in different columns. 

(if you actually have a column with a date rather then a month the would be better because you could use the slicer to filter by date otherwise you can only do it by month as your header, but that could cause and issue if you are looking at past years or once you reach the next year) but for our example it would be the same process.

Your data would look now something like this, I would rename Attribute to Month then Close and Apply.

Insert a Matrix table and add your values as shown below.  Then you can just add a month slicer which you can select different months at the same time.  (Again if you have a date rather then a month that would allow you to do what you need above and instead of months you would select the months in between).