Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
99 | |
82 | |
70 | |
63 |
User | Count |
---|---|
145 | |
111 | |
104 | |
84 | |
64 |