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.
so here is my situation, i have 2016 Jan to Dec bookings, and 2017 Jan to March bookings. I am trying to use divide to do a Y/Y growth %. The results looks fine from 2017 Jan to March. However, from 2017 April to Dec, i got -100% because there is no actual yet in 2017.....how to make these -100% to be blank?
thank you!!
Solved! Go to Solution.
DIVIDE() function can only deal with "0" denominator scenarios. Now you can want to apply condition based on current row, so you have to use IF statement.
= IF ( [Bookings CY] = BLANK (), ( [Bookings CY] - [Bookings LY] ) / [Bookings LY], BLANK () )
Regards,
DIVIDE() function can only deal with "0" denominator scenarios. Now you can want to apply condition based on current row, so you have to use IF statement.
= IF ( [Bookings CY] = BLANK (), ( [Bookings CY] - [Bookings LY] ) / [Bookings LY], BLANK () )
Regards,
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 |
---|---|
112 | |
97 | |
78 | |
68 | |
55 |
User | Count |
---|---|
145 | |
105 | |
104 | |
90 | |
63 |