Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.13 | X |
12.13 | X |
12.12 | X |
12.11 | X |
12.1 | O |
12.1 | O |
12.1 | O |
12.09 | O |
12.08 | O |
12.08 | O |
Any help, please?
Thank you
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
User | Count |
---|---|
96 | |
85 | |
77 | |
66 | |
63 |
User | Count |
---|---|
110 | |
96 | |
96 | |
67 | |
59 |