Forum Discussion
Compare two columns' values
Anonymous if these are columns, add the new column using the following expression, based on your expression, looks like these are columns.
New Column = SWITCH ( TRUE(), Table[Allocation Requested] = Table[Allocation Actual], "Allocation Match", Table[Allocation Requested] < Table[Allocation Actual], "Over allocated", "Requested too high" )Check my latest blog post Improve UX: Show Year in Legend When Using Time Intelligence Measures | PeryTUS IT Solutions I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡
I am trying to determine if a value appears in a column in two different tables...for example
Device Names in table one are
ABC123
DEF456
Device Name in table two are
ABC123
GHK789
So the ABC123 would produce a positive result of some sort, don't really care what
Whereas DEF456 and GHK789 would BOTH produce negative results for investigation.
The idea being to create some sort of action table to enable us to understand gaps in our data in various systems where the data should exist.
Hi,
In TableA, write this calculated column formula
Present in TableB = lookupvalue('tableb'[Code],'tableb'[Code],'tablea'[Code])
In TableB, write this calculated column formula
Present in TableA = lookupvalue('tablea'[Code],'tablea'[Code],'tableb'[Code])
Hope this helps.
Perfect, thanks Ashish
You are welcome.
