Showing results for 
Search instead for 
Did you mean: 
srisandanavelli Frequent Visitor
Frequent Visitor

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.


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.
Community Support Team
Community Support Team

Re: Getting comparison in Column

Hi @srisandanavelli ,


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] ),
        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.



Xiaoxin Sheng

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

For learning resources/Release notes, please visit: | |