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.
Im trying to get this Nested IF statement to work:
Goal% = [Goal Count] / IF([Period] = "Current Month",1,IF([Period] = "Trailing 3" , 3,IF([Period] = "YTD" , 12,"")))
Solved! Go to Solution.
I'd need to see data to really see what is going on, but in your last IF statement, if it isn't "Current Month", "Trailing 3", or "YTD" it will try to divide by "", which cannot happen.
Try this to clean that up:
Goal% = DIVIDE ( [Goal Count], IF ( [Period] = "Current Month", 1, IF ( [Period] = "Trailing 3", 3, IF ( [Period] = "YTD", 12, 0 ) ) ), 0 )
That will provide a safe divide where dividing by zero will return zero instead of an error. THat might clean that Function Placeholder error
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingI'd need to see data to really see what is going on, but in your last IF statement, if it isn't "Current Month", "Trailing 3", or "YTD" it will try to divide by "", which cannot happen.
Try this to clean that up:
Goal% = DIVIDE ( [Goal Count], IF ( [Period] = "Current Month", 1, IF ( [Period] = "Trailing 3", 3, IF ( [Period] = "YTD", 12, 0 ) ) ), 0 )
That will provide a safe divide where dividing by zero will return zero instead of an error. THat might clean that Function Placeholder error
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingCovering 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 |
---|---|
115 | |
100 | |
88 | |
69 | |
61 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |