Each if in DAX?

Question

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

jihwan_kim · Accepted Answer

Hi,
I am not sure if I understood your question correctly, but I tried to create a sample pbix file like below.
Please check the below picture and the attached pbix file.
I hope the below can provide some ideas on how to create a solution for your datamodel.
It is for creating a new column.
&nbsp;

&nbsp;
&nbsp;

&nbsp;
&nbsp;
Category CC =
SUMMARIZE (
    FILTER (
        Category,
        Category[Min] &lt; Data[Vektdiff]
            &amp;&amp; Category[Max] &gt;= Data[Vektdiff]
    ),
    Category[Category]
)

&nbsp;

Forum Discussion

Each if in DAX?

2 Replies

Related content

Dax

DAX

DAX Behavior

DAX Formula Help

DAX