Looking for specific text in cell based on another column
I'm trying to do a Find/Mid/Match in Power Query, but I'm not sure how to do it. Basically, I have a long list of article numbers and article names - inside these articles names it's stated which colour the product is. The issue is that it's not always in the same place. I have a query named "X_Colours" with one column "Colours" type is Text. Other query is "Items" with two columns "Item No" (Number) and "Name" (Text). I would like a custom column that looks in "Items" "Name" for a similar value from "X_Colours" "Colours" column. If it finds the same value, it should return the value from "X_Colours" if not, it should just return something like "Unknown", so I can manually look for the colour and add it to the list. Is this possible or do I have to create a new table and use an excel formula and then add it back into the query? Thanks in advance!
Unmatched Row count with aggregation with Region
Hello Friends, Please help me, I am new to Power bi and looking for the desired output for a week now but no luck, I have 5 tables in which 3 are dimtable (Dim_date,Dim_Taskid,Dim_Region) and 2 table as (Table1 and Table2) and these 2 table are connected to Dim_table with M-to 1 relationship. Table 1 and 2 has duplicate ,Date, Taskid,Region. let me break down the measure i am looking for as below. when i filter dates it should 1. First compare Table1 with Table 2 and select all the taskid which are unmatched. it should select the distinct match. 2. then aggregate(Sum or count) unmatched Taskid (Which is a output from point 1) with region. Please see the output Let me explain it with example 1. First select all the taskid matched as per filtered date(Jan-Aug) . 2Then count the taskid with Region . Regards
