cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
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.

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.
 
6.PNG
Need the above highlighted row as column value for each row.
 
Please suggest and feel free to reach out for any information.
1 REPLY 1
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] ),
    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

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: | |