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.
Hello - Using the measure below, I am getting the following results in my table.
The -100 % values are for periods (days or months) where we do not have any 2020 values yet.
How can constrain this measure to only show the values with actual comparisons data between 2020 and 2019. Not the - 100% values ?
Solved! Go to Solution.
@Anonymous
Try something like this:
YOY Orders Rcvd Var % =
IF ( [2020 Sum of Recvd Orders] = 0,
BLANK(),
([2020 Sum of Recvd Orders]-[2019 Sum of Orders])/[2019 Sum of Orders])
@Anonymous
Try something like this:
YOY Orders Rcvd Var % =
IF ( [2020 Sum of Recvd Orders] = 0,
BLANK(),
([2020 Sum of Recvd Orders]-[2019 Sum of Orders])/[2019 Sum of Orders])
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 |
---|---|
113 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |