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.
Hi
I am trying to calculate a column called Differential based on different IF condition . However , when I am using nested IF statements I am getting this error. I tried using Switch statement too but that didnt work because Switch doesnt work with calculated columns ?
Query
Solved! Go to Solution.
Re-wrote the query and it worked. Thanks all for your inputs
Hi @Anonymous ,
I found a negative sign before FILTER(). I think it may be a comma.
-FILTER(ALLSELECTED(NGPricesOneLine)
-->
,FILTER(ALLSELECTED(NGPricesOneLine)
Thanks for your response. "-" sign is for subtraction. I have to subtract corresponding values for different sources from ABC or ice versa. Have explained the issue above with sample source data .
Thanks for your help
Here's some general guidance: Look at your query on http://www.daxformatter.com/
That helps you visualize the logic, and also helps you identify repetitive calculations that are better done once, using variables.
Also note that "ABC" is not the same as {"A","B","C"} but I guess you knew that already.
Thanks for the reply lbendlin I ran my query through DAX formatter and it looks okay. Couldnt find any flaws .
I didnt copy my source data for you all to understand and suggest changes . Mentioned below is my source data
Differential is a calculated column
Differential | Source Name | Month | PriorSettle |
1 | ABC | Jul-20 | 1 |
2 | ABC | Aug-20 | 2 |
3 | ABC | Sep-20 | 3 |
4-2=2 | C | Aug-20 | 4 |
1-3=-2 | C | Sep-20 | 1 |
2-0=2 | C | Oct-20 | 2 |
2-1=1 | D | Jul-20 | 2 |
5-2=3 | D | Aug-20 | 5 |
1-4=-3 | G | Jul-20 | 4 |
2-2=0 | G | Aug-20 | 2 |
I have to calculate this column on the basis of where Source is "ABC" and a matching month , if Source is C,D, .. , I should subtract the value of "ABC" from C,D.. if its G, H.. I have to subtract the values from "ABC". IF its ABC , the priorsettle should stay as is. PLease note all of this needs to be matched on a month.
I am pretty new to POwerBI hence please feel free to suggest if my entire apprach to calculate these values is not correct
Thanks for your help
Re-wrote the query and it worked. Thanks all for your inputs
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 |
---|---|
101 | |
49 | |
19 | |
12 | |
11 |