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.
I'm sure someone can easily resolve this, I can't. Here is my DAX for Current Yr Growth %:
Solved! Go to Solution.
I created a new column for previous years sales, I think I was using SAMEPERIODLASTYEAR somewhere and that was messing things up.
I created a new column for previous years sales, I think I was using SAMEPERIODLASTYEAR somewhere and that was messing things up.
Hi @cbtekrony ,
It seems that in the rows which the value of Current Yr Growth % is blank, the corresponding values of YOY_Sales and py_sales is blank (one of them is blank or both are blank). Could you please provide the formula of measure [Total Past ACV and Estimate] and sample data in relevant tables to make troubleshooting in order to find the cause to solve it? Thank you.
Best Regards
Rena
interesting. have you tried to debug?
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 | |
85 | |
67 | |
59 |
User | Count |
---|---|
150 | |
120 | |
100 | |
87 | |
68 |