Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Getting comparison in Column

Hi All,

 

I have 7 calculated columns and need to compare the counts for various years.

I am trying to get the chage value as column but unable to get it .
If I create the Change  measure as Column it throws error for SAMEPERIODLASTYEAR which i have used.

Meausres:

FY-FY Change = IF([No of key Risks]-[Next\Pevious year]>0 ,"Low", "Up")

Where No of key risks is a measure.
Next\Pevious year= No of key risks for pervious or next year.
 
Need the above highlighted row as column value for each row.
 
Please suggest and feel free to reach out for any information.
Need Help

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Hi Anonymous ,

     

    Did these FY field measure or column? If column, you can add a measure with if condition to check current row contents to switch measure result of current formula.

    Measure =
IF (
    ISFILTERED ( Table[FY] ),
    CALCULATE (
        SUM ( Table[Value] ),
        ALLSELECTED ( table ),
        VALUES ( Table[Cateogry] )
    ),
    IF ( [No of key Risks] - [Next\Pevious year] > 0, "Low", "Up" )
)

     

    If they are measures, you can direct add three measures to value field and remove column fields.

     

    Regards,

    Xiaoxin Sheng