Forum Discussion

vasathi's avatar
vasathi
Helper II
5 years ago
Solved

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...
Need Help
  • vasathi's avatar
    vasathi
    5 years ago

    This formula not working and still the same result. 

     

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

selimovd's avatar
selimovd
Most Valuable Professional
5 years ago

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
 
vasathi's avatar
vasathi
Helper II
5 years ago

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