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.

Fowmy's avatar
Fowmy
Super User
5 years ago

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

 

 

vasathi's avatar
vasathi
Helper II
5 years ago

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