Forum Discussion

JimSales81's avatar
JimSales81
Helper I
1 year ago
Solved

Compare Dynamic Columns in a Matrix

My Users like to see Quarter over Quarter sales so i've created a measure for each quarter's sales going back to Q1/2024 and added to a matrix. Some like to see $ change and % change from previous qu...
  • v-nmadadi-msft's avatar
    v-nmadadi-msft
    1 year ago

    Hi  JimSales81 ,


    Well there isn't any explicit restriction on field parameters that would prevent us from using measure selection when working with two field parameters.
    Just that in practice, it isn’t behaving as expected when trying to create a dynamic difference between two field parameters.


    Thank you

FBergamaschi's avatar
FBergamaschi
Super User
1 year ago

Can you share the pbix via some cloud service?

 

Anyway the solution to me is a visual calculation, but I need to see the matrix to give you he code (or you share th epbix and I do on the pbix directly)

 

If this helped, please consider giving kudos and mark as a solution

me in replies or I'll lose your thread

Want to check your DAX skills? Answer my biweekly DAX challenges on the kubisco Linkedin page

Consider voting this Power BI idea

Francesco Bergamaschi

MBA, M.Eng, M.Econ, Professor of BI