topic Re: Compare 2 values from 2 different tables and show the ICON(Up Arrow, Down Arrow) in 3rd Column in DAX Commands and Tips

Compare 2 values from 2 different tables and show the ICON(Up Arrow, Down Arrow) in 3rd Column

arun2001mjl — Tue, 01 Feb 2022 13:21:32 GMT

Hello All,

Need your help on this in PowerBI Dax.

I have 2 tables called Last month(Dec 21) & Current Month(21) which has ticket counts and account names.

I need to compare both the values in Last month & Current month and show the ICON in 3rd column as ..

Last month ticket count > Current Month ticket count : Down Arrow

Last month ticket count < Current Month ticket count: Up Arrow

Last Month ticket count = Current Month ticket count: Equal Arrow

Is this possible in powerbi?

Table Names	Table 1	Table 2
Account	Last month Ticket count	Current Month ticket count	Comparison
A	9456	2345
B	2345	23433
C	23842	6565
D	4343	5656
E	4545	9456
F	232	4343
G	4343	4343
H	677	232

Regards

Arun

Re: Compare 2 values from 2 different tables and show the ICON(Up Arrow, Down Arrow) in 3rd Column

ValtteriN — Tue, 01 Feb 2022 13:30:47 GMT

Hi,

Try somethin like this:

Column 2 =

var _item = ItemExample[Item]

var _value = CALCULATE(SUM('Matrix example'[Value]),ALL('Matrix example'),'Matrix example'[Item]=_item)

return

SWITCH(TRUE(),_value>ItemExample[Column],UNICHAR(11165),

_value<ItemExample[Column],UNICHAR(11167),

_value=ItemExample[Column],UNICHAR(11166))

I am using Item instead of Account but the logic is the same.

End result:

I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!

My LinkedIn: https://www.linkedin.com/in/n%C3%A4ttiahov-00001/

Re: Compare 2 values from 2 different tables and show the ICON(Up Arrow, Down Arrow) in 3rd Column

Anonymous — Wed, 09 Feb 2022 02:07:39 GMT

Hi arun2001mjl ,

Any updates? I think ValtteriN 's method is efficient.

Could you tell me if your problem has been solved? If it is, kindly Accept it as the solution. More people will benefit from it. Or if you are still confused about it, please provide me with more details about your table and your problem or share me with your pbix file after removing sensitive data.

Best Regards,
Eyelyn Qin