Skip to main content
Announcements
Global Transformation Awards! Applications are now open. Submit Entry
cancel
Showing results for 
Search instead for 
Did you mean: 
Bharathi09
Creator II
Creator II

Applumap and Left join

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 🙂

Labels (4)
2 Replies
TauseefKhan
Creator III
Creator III

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

Bharathi09
Creator II
Creator II
Author

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?