Need to create a True\False Column that..

[Tirith]

Hello!

I need to create a Column that with the Value either True or False, based on a if there is an entry into another table. 

So I have two queries, which a relationship between the two linked at Name. One  Query is something like a master list of all systems with some general data about each one.  The second queries only lists systems that need to be restarted, however it only lists Name and IP address, I can't do much to change the sorce data. 

In my table visualation I want to add a column that if the name appears in the second query it value is set to true, if it's not listed the value is set to false. 

[Ritaf1983 · Accepted solution]

Hi @Tirith 
Please refer to the linked discussions

https://community.fabric.microsoft.com/t5/Desktop/DAX-query-to-compare-a-value-in-one-table-to-see-i...

https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Calculated-column-checking-if-value-...

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.

[Anonymous · Accepted solution]

Hi @Tirith 

You can use if() and filter() function to this.

You can refer to the following link.
IF function (DAX) - DAX | Microsoft Learn

FILTER function (DAX) - DAX | Microsoft Learn

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Ritaf1983 · Accepted solution]

Hi @Tirith 
Please refer to the linked discussions

https://community.fabric.microsoft.com/t5/Desktop/DAX-query-to-compare-a-value-in-one-table-to-see-i...

https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Calculated-column-checking-if-value-...

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.