cancel
Showing results for
Did you mean:

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Helper II

## Dax % showing incorrectly

Team,

I have a problem to calculating the % for CY vs LY.

I Used following.

But my result is showing wrong like

i dont' know how to fix.  Great thanks to Someone will help me to fix this output

Regards

1 ACCEPTED SOLUTION
Helper II

This formula not working and still the same result.

Anyway i have fixed as work-arround with round function and got resolved.

5 REPLIES 5
Super User

@vasathi

Can you change the Divide function as follows and try?

VAR _Grate = DIVIDE ( _TYamt - _lYamt , _lYamt )

If this doesn't work, please provide some sample data and the expected results

Did I answer your question? Mark my post as a solution! and hit thumbs up
Helper II

This formula not working and still the same result.

Anyway i have fixed as work-arround with round function and got resolved.

Helper II

Dear Fowmy

Thanks for update. Some how I managed to return

I modified like

VAR = Round (ActualYTD,2)

VAR = Round (ActualSPLY,2)

Then my results are came as expected.

Thanks for your suggestions also and will try

Super User

Hey @vasathi ,

can you in the same table put [ActualYTD] and [ActualSPLY].

The division should not be the problem, but I guess one of the two measures is returning a result you don't expect.

Also in your table I don't know which of the 4 columns is your measure as you don't tell us the name and don't show the header. I can only guess the percentage formatted, but I don't know.

If you need any help please let me know.
If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

Best regards
Denis

Helper II

Dear Selimovd

Exactly the measure I am calculated to find growth %.

I am not hiding anything in the first 4 lines.

I have managed with following

VAR = Round (ActualYTD,2)

VAR = Round (ActualSPLY,2)

And it's working as expected.

Announcements

#### New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

#### Power BI Monthly Update - May 2024

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

#### Fabric certifications survey

Certification feedback opportunity for the community.

Top Solution Authors
Top Kudoed Authors