Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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!
User | Count |
---|---|
98 | |
90 | |
83 | |
70 | |
67 |
User | Count |
---|---|
113 | |
104 | |
101 | |
73 | |
65 |