The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Hi,
I'm fairly new to Power BI so seeing if someone can help me with my script or if the issue lies in my data.
The formula i'm trying to create and having issues with is located on the second line. If Fiscal Year doesn't equal 2020 and 2017, and Account Code equals 527990, then insert 0. Without this line, I don't have any issues, but when I insert (2020 or 2017), I get the error below.
There are no blanks in Fiscal Year, and both Data Types are consistent of Whole Numbers.
Help is appreciated!
Solved! Go to Solution.
Proud to be a Super User!
The problem is in the (2020 or 2017) part. the OR operator expects two seperate comparisons, not a summation of elements.
Try this
else if ([Fiscal Year]<>2020 or [Fiscal Year]<>2017) and .....
Kind regards
Djerro123
-------------------------------
If this answered your question, please mark it as the Solution. This also helps others to find what they are looking for.
Kudo's are welcome 🙂
Proud to be a Super User!
Thanks for the explanation and solution Djerro, it solved the error issue however I think due to my "not" <> operator and order of things, it's spitting out results i'm not looking for. I tried to just target the combination of Fiscal Year and Account Code for each year, i.e. Fiscal Year 2018 and Account Code #### then 0, but still not getting the correct results.
Will play around more and update if I find a solution.
Proud to be a Super User!
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
98 | |
92 | |
90 | |
72 | |
69 |
User | Count |
---|---|
232 | |
128 | |
117 | |
82 | |
82 |