Forum Discussion
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 thi...
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")))
Thank you so much !
but the problem is there are more mold sizes ( a dozen more)
so it has to be dynamic TT