Problem dealing with variation between columns

Question

Good morning! I need help with something specific, I need to make the variation between these two columns "Utilização Livre&nbsp; 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"?

v-kkf-msft · Accepted Answer

Hi&nbsp;Anonymous&nbsp;,
&nbsp;
Please add a custom column in Power Query Editor.
&nbsp;
= [Utilização Livre 06 06] - [Utilização Livre  06 02]

&nbsp;
And you can also add icons&nbsp;by rules.
https://docs.microsoft.com/power-bi/create-reports/desktop-conditional-table-formatting&nbsp;
&nbsp;

&nbsp;
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,WinnizIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
&nbsp;

Forum Discussion

Related content

Variations on December

Logic problem?

DAX calcul variations

Slider problems

FILTERING PROBLEM