The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event: Join us in Stockholm, September 24-27, 2024.
Save €200 with code MSCUST on top of early bird pricing!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Hello, please help )
I need to change value (text type) from mapping table. But it is important to keep the filter (not to use Merge table 😞 )
what I have
Table1
Table 2
I applied the solution:
= List.Accumulate(
{0..List.Count(Table2[number])-1},
#"previous step",
(state, current) => Table.ReplaceValue (state,Table2[number]{current},
Table2[decode]{current}, Replacer.ReplaceText,{"Zones"}
) )
and i have this : -(
but i need to use filter according to crf_form_id
thanks in advance
Solved! Go to Solution.
not very performant but one step
replace = Table.ReplaceValue(
Table1,
(o) => o[crf_form_id],
(n) => n[Zones],
(v, o, n) =>
try Table2{[crf_form_id = o, number = n]}[decode]
otherwise null,
{"Zones"}
)
@dariaglb
From what I understand, you want to add zones from table 2 to table 1 with a join condition based on two columns
you can do it power query, please follow the steps mentioned here: https://community.fabric.microsoft.com/t5/Power-Query/Join-on-multiple-columns-using-Power-query/m-p...
If the post helps please give a thumbs up
If it solves your issue, please accept it as the solution to help the other members find it more quickly.
Tharun
Thank you for your message, I tried to depict
result
yes, it'll work... but the table has a lot of columns and the task requires not to use the function Merge
not very performant but one step
replace = Table.ReplaceValue(
Table1,
(o) => o[crf_form_id],
(n) => n[Zones],
(v, o, n) =>
try Table2{[crf_form_id = o, number = n]}[decode]
otherwise null,
{"Zones"}
)
If you don't want use Merge, you can achieve the same by adding this as custom column to Table1.
Table.SelectRows(Table2, (x)=> x[crf_form_id] = [crf_form_id] and x[number] = [Zones])[decode]{0}?
To be honest I don't understand why don't you want use merge - it is faster solution.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
36 | |
23 | |
23 | |
18 | |
16 |