Power BI: How to change an attribute to a separate table?

[arjun_para]

I want to change an attribute to a separate table.

For example New joinees is an attribute. I want to create a separate table for new joinees in powerbi.

Please see the attached image

[fahadqadir3 · Accepted solution]

@arjun_para You need to filter the table, you can do that in Power Query or in DAX and create a new filtered Table. Please review the attached screenshots

Only new Joinee = CALCULATETABLE('Table','Table'[Attribute] = "New joinees")

@arjun_para Hope it works.

Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!! 

[arjun_para]

Thanks fahadqadir3 and Yulia Xu. 
I really appreciate your help.

Case closed

[fahadqadir3]

@arjun_para  Mark my post as a solution! This will help others on the forum! Appreciate your Kudos!!

[Anonymous · Accepted solution]

Hi @arjun_para 

Thanks for the reply from @fahadqadir3 , please allow me to provide what it would take to achieve this effect in Power Query:

1. Right-click on the table and select "Duplicate" to create a new table.

2. Filtering on Attribute columns

Close & Apply

Output:

Best Regards,
Yulia Xu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[fahadqadir3 · Accepted solution]

@arjun_para You need to filter the table, you can do that in Power Query or in DAX and create a new filtered Table. Please review the attached screenshots

Only new Joinee = CALCULATETABLE('Table','Table'[Attribute] = "New joinees")

@arjun_para Hope it works.

Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!