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.
Hola!
Tengo una columna con valores positivos y negativos que he cargado desde un fichero excel. Necesito que los numeros que son negativos pase a positivos y que los positivos se conviertan en negativos. Por ejemplo;
Si tengo -150, quiero obtener 150
Y en la misma columna, si tengo 250, quiero obtener -250
Todos los numeros aparecen en una sola columna.
Alguien tiene idea de como hacerlo? He probado con valores absolutos, pero esto mantiene los positivos y no los modifica a negativos.
Gracias!
Solved! Go to Solution.
Hi @JessicaM ,
Just create a new column which multiplies the column with -1
Thanks! I was looking for a formula to calculate the values, but this is perfectly working. Thanks!
@JessicaM , That seems strange. Have you used some kind of formatting in excel. Which is showing data that way
Or open power query and check for any steps that is doing this
Hi @amitchandak,
Yes, this information is coming from an excel file. But they are extracted from a database with this format. Do you know how to make the change? I found nothing in Power Query so far 😞
Thanks!
Hi @JessicaM ,
Just create a new column which multiplies the column with -1
Thanks! I was looking for a formula to calculate the values, but this is perfectly working. Thanks!
@JessicaM , Would it possible for you to share a sample so that I can try?
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 |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
93 | |
84 | |
66 |