Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I have a table of sales order data, and a second, linked table that contains information about communications with customers in relation to the sales orders. The second table has a column called "category". What I would like to do is add a column to the sales data table that flags true if there is a note in the second table with a specific category. Is this doable?
There will be other categories in the second table that need to be ignored, and there may be more than one note tagged as the category I want to look for.
Solved! Go to Solution.
You can add a calculated column something like
Has note on category = NOT( ISEMPTY(
FILTER( RELATEDTABLE( Notes ), Notes[Category] IN { "category 1", "category 2" } )
))
Hi @MHatMFT ,
Yes, you could do that.
But we need more details about your table and your expected output to clarify your scenario.
Could you please provide some dummy data or share with your pbix file after removing sensitive data?
For reference:
How to provide sample data in the Power BI Forum - Microsoft Power BI Community
How to Get Your Question Answered Quickly - Microsoft Power BI Community
Best Regards,
Eyelyn Qin
You can add a calculated column something like
Has note on category = NOT( ISEMPTY(
FILTER( RELATEDTABLE( Notes ), Notes[Category] IN { "category 1", "category 2" } )
))
Thanks, that worked
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
99 | |
74 | |
63 | |
62 |
User | Count |
---|---|
143 | |
104 | |
102 | |
81 | |
66 |