Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello
I need to create a calculated column from other column wich shows certain quantity , when the column "Planta" and the column "Centro_Receptor" exchange positions I need the "cantidad" value in other column
For example for the week 51 form 1024 to 1023 is 166 and form 1023 to 1024 is 424, so the result must be
0
424
0
166
I need some help please!
@Anonymous
May be something like this
Column = VAR VAL = LOOKUPVALUE ( [Cantidad], [PLANTA], [CENTRO_RECEPTOR], [CENTRO_RECEPTOR], [PLANTA] ) RETURN IF ( VAL = [Cantidad], 0, VAL )
Hello @Zubair_Muhammad
Thanks for the answer, unfortunatly it didnt worked, i think might be because I have other values in the "Semana" column and in the planta column
Do you think anorther solution?
Hi @Anonymous,
To get the solution quickly, please share your sample data as table format and your desired output so that we can copy and test on it.
Best Regards,
Cherry
User | Count |
---|---|
94 | |
79 | |
73 | |
63 | |
59 |
User | Count |
---|---|
110 | |
103 | |
84 | |
65 | |
62 |