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

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

Reply
vasathi
Helper II
Helper II

Dax % showing incorrectly

Team,

 

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

 

I Used following.

vasathi_0-1625923967803.png

 

But my result is showing wrong like 

vasathi_1-1625924025925.png


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


Regards

 

1 ACCEPTED SOLUTION

This formula not working and still the same result. 

 

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

View solution in original post

5 REPLIES 5
Fowmy
Super User
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


Subscribe and learn Power BI from these videos

Website LinkedIn PBI User Group

This formula not working and still the same result. 

 

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

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 

 

 

selimovd
Super User
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
 

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.

 

Thanks for your suggestions

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

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

MayPowerBICarousel

Power BI Monthly Update - May 2024

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

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.