The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Hi Guys,
I don't know if its possible but i want to Create an IF statement but coordinated with 2 Table.
Image below for clarity.
I have 6 Tables All of them have the Same first name but different Role/Labour Category.
Employee List table have the Labour category which i want to Put into the Level1-5 Role column.
as far my Program line as below which is not working.
if Employeelist[First name] = Level1[First Name] then Employeelist[Labour Category] = Level1[Role] else Level1[Role] = null
Hoping you could help me again.
thank you.
Cheers,
Solved! Go to Solution.
@iyogj Why do you need 6 tables? can this all be in one table?
I would suggest you start with the Employee table, then from the Home tab > Merge Queries. Select the Level 1 table, pick the First Name columns in both tables, click Ok.
You'll now have a new column, click the two arrows next to the column heading for this new column and select all the columns you want included from the Level1 table.
Copying DAX from this post? Click here for a hack to quickly replace it with your own table names
Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C
I work as a Microsoft trainer and consultant, specialising in Power BI and Power Query.
www.excelwithallison.com
@iyogj Why do you need 6 tables? can this all be in one table?
I would suggest you start with the Employee table, then from the Home tab > Merge Queries. Select the Level 1 table, pick the First Name columns in both tables, click Ok.
You'll now have a new column, click the two arrows next to the column heading for this new column and select all the columns you want included from the Level1 table.
Copying DAX from this post? Click here for a hack to quickly replace it with your own table names
Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C
I work as a Microsoft trainer and consultant, specialising in Power BI and Power Query.
www.excelwithallison.com
Hi @AllisonKennedy ,
Thank you for your response.
The Employeelist Table is manually added by different people and the Levels are automatically added from HR software. that's why they are in the different table.
i tried your solution it works but vice versa but the idea is the same. Really thank you. apologies if the solution is so simple enough i am very new to PowerBI.
Cheers,
@iyogj no need to apologize, that's what learning and this forum is for. Glad it's working!
Copying DAX from this post? Click here for a hack to quickly replace it with your own table names
Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C
I work as a Microsoft trainer and consultant, specialising in Power BI and Power Query.
www.excelwithallison.com
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 |
---|---|
99 | |
93 | |
81 | |
63 | |
56 |
User | Count |
---|---|
248 | |
123 | |
111 | |
78 | |
74 |