each
1 Topic
Each if in DAX?
Hi, I have a table with percentages, and I want to add another table with only five values: >5% 2<x<5 % (-2)<x< 2 % (-5)<x<(-2) % <(-5)% How can I do this in Power BI Desktop? (One of the columns the percentages are based on is from another table. I tried something like this: Diff = IF(AND('AssessDataForEachProduct-AllApp'[Vektdiff]<2,'AssessDataForEachProduct-AllApp'[Vektdiff]>-2),"-2<x<2",IF(AND('AssessDataForEachProduct-AllApp'[Vektdiff]>2,'AssessDataForEachProduct-AllApp'[Vektdiff]<5),"+2%",IF(AND('AssessDataForEachProduct-AllApp'[Vektdiff]<-2,'AssessDataForEachProduct-AllApp'[Vektdiff]<-5),"-2%",IF('AssessDataForEachProduct-AllApp'[Vektdiff]>5,5,IF('AssessDataForEachProduct-AllApp'[Vekt]<-5,-5,0))))) ... which didn't work. Thanks, SigridSolved1.5KViews0likes2Comments