Forum Discussion

kcjeongzz's avatar
kcjeongzz
New Member
7 years ago

DAX HELP!!

Hello guys,

 

I want to determine if the Width Value from the left chart is between Width and Width2 from the right chart for every row.

 

For example, I want the DAX to be expressed in this way so I can calculate the total percentage later.

 

12.13X
12.13X
12.12X
12.11X
12.1O
12.1O
12.1O
12.09O
12.08O
12.08O

 

Any help, please?

 

Thank you 

 

Need Help

2 Replies

  • harslan66's avatar
    harslan66
    Frequent Visitor
    7 years ago

    You can use something like this:

     

    Mold SIze = IF(AND(Table2[Width Value]>=12.40,Table2[Width Value]<=12.40),"No 0",
    IF(AND(Table2[Width Value]>=11.90,Table2[Width Value]<=12.10),"No 1",
    IF(AND(Table2[Width Value]>=11.00,Table2[Width Value]<=11.10),"No 2","NA")))

    • kcjeongzz's avatar
      kcjeongzz
      New Member
      7 years ago

      Thank you so much !

      but the problem is there are more mold sizes ( a dozen more)

       

      so it has to be dynamic TT