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

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
ngomes
Helper II
Helper II

Help - DAX formula

Hello everyone,

I would like to ask you for help with a problem I have with a calculated column 22VS21.
what I wanted was that the column 22vs21 = (2022 values - 2021 values) / 2021 values

the calculations should result to client 1
22vs21 = (300 - 200) / 200 = 0,5

1636028356742.png

 

the table with the results

1636028425824.png

I can't understand what I'm doing wrong in the formula, can someone help me?

1 ACCEPTED SOLUTION
smpa01
Super User
Super User

@ngomes  instead of using calculated column, you need to use measures 

MEASURE = DIVIDE((SUM(tbl[2022])-SUM(tbl[2021]))/SUM(tbl[2021]))

 Unless you use measures, the values from calculated table will not be aggregated the way you are desiring. 

Did I answer your question? Mark my post as a solution!
Proud to be a Super User!
My custom visualization projects
Plotting Live Sound: Viz1
Beautiful News:Viz1, Viz2, Viz3
Visual Capitalist: Working Hrs

View solution in original post

2 REPLIES 2
smpa01
Super User
Super User

@ngomes  instead of using calculated column, you need to use measures 

MEASURE = DIVIDE((SUM(tbl[2022])-SUM(tbl[2021]))/SUM(tbl[2021]))

 Unless you use measures, the values from calculated table will not be aggregated the way you are desiring. 

Did I answer your question? Mark my post as a solution!
Proud to be a Super User!
My custom visualization projects
Plotting Live Sound: Viz1
Beautiful News:Viz1, Viz2, Viz3
Visual Capitalist: Working Hrs

that's right, thanks so much for the help.

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

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