Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
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.
Hi @Tirith
Please refer to the linked discussions
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.
User | Count |
---|---|
94 | |
86 | |
78 | |
69 | |
63 |
User | Count |
---|---|
113 | |
99 | |
97 | |
64 | |
59 |