Forum Discussion
Problem dealing with variation between columns
Good morning! I need help with something specific, I need to make the variation between these two columns "Utilização Livre 06 02 and Utilização Livre 06 06", which in itself is not something complicated. However, how do I show if this variation was negative or positive? For example, in the first value, on day 06 02 we have 290k of pieces and on day 06 06 we have 50k, the variation of the two is -240k How i show this in power bi? How i show that they had a negative output and how to display "-240k"?
Hi Anonymous ,
Please add a custom column in Power Query Editor.
= [Utilização Livre 06 06] - [Utilização Livre 06 02]And you can also add icons by rules.
https://docs.microsoft.com/power-bi/create-reports/desktop-conditional-table-formatting
If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
Best Regards,
Winniz
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
1 Reply
Hi Anonymous ,
Please add a custom column in Power Query Editor.
= [Utilização Livre 06 06] - [Utilização Livre 06 02]And you can also add icons by rules.
https://docs.microsoft.com/power-bi/create-reports/desktop-conditional-table-formatting
If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
Best Regards,
Winniz
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.