Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

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
v-shex-msft
Community Support
Community Support

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

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

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.