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
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
Solved! Go to Solution.
This formula not working and still the same result.
Anyway i have fixed as work-arround with round function and got resolved.
@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
⭕ 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
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.
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
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
111 | |
108 | |
108 | |
93 | |
61 |
User | Count |
---|---|
169 | |
138 | |
135 | |
102 | |
86 |