Compare Dynamic Columns in a Matrix

Hi JimSales81 
Thanks for reaching out to the Microsoft fabric community forum.

Since using two field parameter selections as variables isn't yielding the desired results, consider modifying your approach by creating two separate measures  one for 'Compare with Previous Quarter' and another for 'Compare with Same Quarter Last Year'. Then, use a field parameter to allow users to select only the end quarter.

The start quarter will be dynamically determined within each measure based on the selected comparison type.

Instead of relying on both a start and end quarter selection via field parameters, simplify the design by allowing users to select only the end quarter using a field parameter. Then, create two separate comparison measures:

• One measure to calculate the difference from the previous quarter.
• Another measure to calculate the difference from the same quarter in the previous year.

Each of these measures will internally determine the appropriate start quarter by offsetting the selected end quarter. For example:

• The “Compare with Previous Quarter” measure will find the quarter immediately before the selected end quarter.
• The “Compare with Same Quarter Last Year” measure will look 4 quarters back.

These calculations can be handled within DAX using functions like DATEADD, PARALLELPERIOD, or custom quarter logic using a date table.

I hope this information helps. Please do let us know if you have any further queries.
Thank you