Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi all,
I tried to find percenatge differnce with the two values...its calcualtion perfectly done in power bi .Here am adding data exported from power bi for reference...
1st image is data for calcualtion...ie...here am taking two month average rate for comparison...So...March2020 with April2020 by formula as
Rate change value=(New value-old value)/old value
is getting...correctly...But now i am facing here an issue.
2nd image Monthly june 2021 is coming which is not needed and not in the listed in 1st image ...So..Is there any solution for removing june 2021 from the list?plse help..
steps i used are
Average rate=average(values)
Solved! Go to Solution.
@NISHA_S , Try like
Rate Change =
if(isblank([Average rate]), blank(),
IF (
NOT ISBLANK ( [Previous Month]),
DIVIDE (
[Average rate] - [Previous Month],
[Previous Month]
)
))
@NISHA_S , Try like
Rate Change =
if(isblank([Average rate]), blank(),
IF (
NOT ISBLANK ( [Previous Month]),
DIVIDE (
[Average rate] - [Previous Month],
[Previous Month]
)
))
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
106 | |
93 | |
75 | |
62 | |
50 |
User | Count |
---|---|
147 | |
107 | |
105 | |
87 | |
61 |