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