Forum Discussion
How to filter without affecting running total
Hello! I have a column that has a variety of values. I would like to "filter" out the values that are less than 10,000,000 OR greater than -10,000,000. However, I do not want to affect the total at t...
Delta = VAR _total=SUM('Query' [2022] - SUM('Query'[2021]) RETURN IF(_total>10000000||_total<-10000000,_total)
Hello! Thank you for the response.
I tried running this statement but it is mentioning in the RETURN IF statement that the parameter is not in the correct type.