Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello All,
I am doing qlik to PBI migration. I am doing left join in PBI whereever I have ApplyMap in Qlik
product_desc.c_cntry,
ApplyMap('CNTRY',product_desc.c_cntry,' ') as c_cntry_desc,
c_cntry&'-'& ApplyMap('CNTRY',product_desc.c_cntry,' ') as [COO & DESC],
Date,
Supplier
Export,
[Export]&'-'&ApplyMap('CNTRY',[Export],' ') as [Export & DESC],
Destinati
ApplyMap('Supplier',left([Supplier],5),'No Supplier') as Supplier_Desc,
ApplyMap('Supplier',left(purgechar([Destination],' '),5),'No Destination') as Destination_Desc
My doubt is that in here one applymap is to supplier table and other is CNTRY table and after again supplier table comes and after supplier
It's not in a sequence like first will do applymap to supplier table and after cntry table
so should I do like do left joins to First CNTRY table and after that Supplier table or I can do in the sequence of Qlik also
Does it makes any difference?
Please clear this doubt 🙂
Hi @Bharathi09,
In Power BI, similar functionality can be achieved using a combination of Power Query's Merge Queries and DAX functions.
Merge product_desc with CNTRY in Power Query to create c_cntry_desc
Create [COO & DESC] by concatenating c_cntry with c_cntry_desc
Hi @TauseefKhan , Thanks for Replying
My question is that
First will do left of Current table with cntry table
after that will do left join of current table with supplier table
again will do left join of current table with cntry based on another column
and join with supplier also based on another column
Is this correct way to do, like First cntry, supplier. cntry, supplier------This seq
or should I do like first do two join conditions with Cntry then go to supplier
Does it make any difference in both ways or both are same?