Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Calculate Percent Change between two columns in Matrix Visuals

I have following table

 

Date Category Values

2021Q2B10
2021Q4C23
2021Q4D24
2021Q1A56
2021Q1D41
2021Q4D87
2021Q4A90
2021Q3A45

 

 

I want to present it in the Matrix Visuals (it requires to be in Matrix Visuals) where user will choose any two dates from slicer

 And I want to add another column to the right of the Matix which will shows percentage change between dates.

output should look like this but in Matrix Visual:

 

 

 

 

 

 

 

I wrote the following dax but it is not working plus it automatically renders two columns. How can I achive my goals? Any help will be appreciated!

 


Percentage_Change =
VAR SelectStartDate =
    MIN ( 'Table'[Date] )
VAR SelectEndDate =
    MAX ( 'Table'[Date] )
VAR CurrentValue =
    CALCULATE (
        SUM ( 'Table'[Values] ),
        FILTER (
            'Table',
            'Table'[Date] = SelectEndDate
        )
    )
VAR PreviousValue =
    CALCULATE (
        SUM ( 'Table'[Values] ),
        FILTER (
            'Table',
            'Table'[Date] = SelectStartDate
        )
    )
RETURN
    ( CurrentValue - PreviousValue ) / PreviousValue 

 

  • where user will choose any two dates from slicer

     

    How are you planning to enforce that?

     

    Here is a version that simply uses the Min and Max quarter, regardless of how many slicer choices are made.

    Caveat - you cannot suppress the single value total

     

     

     

     

     

2 Replies

  • where user will choose any two dates from slicer

     

    How are you planning to enforce that?

     

    Here is a version that simply uses the Min and Max quarter, regardless of how many slicer choices are made.

    Caveat - you cannot suppress the single value total