Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi All,
I want to add two columns from different tables, which are calculated table.
The sample of the data is in the attached image. It would be great if someone could help me. I am a newbie to power bi.
Regards,
Kumar Ashwarya
Hi
Add both the tables into Power Bi Desktop and you can see relationships tab in left hand side. Using that you can join the matching column (session id)
Thanks
Hari
Actually my purpose is to delete junk data from both the tables, based on the values of table 2. Would this be possible if there they are joined through the relationship model?
@Kumar11109 wrote:
Actually my purpose is to delete junk data from both the tables, based on the values of table 2. Would this be possible if there they are joined through the relationship model?
In DAX you can't delete data from tables but filter them. You can do the deletion in Power Query and no worry about relationship model in DAX.
How would you like to delete data from the sample tables? Could you be more specific?
Thank you guys, for your help and showing interest in solving others problem. Rather than adding a new column, I created a new table using the data from two tables.
Regards,
Kumar Ashwarya