Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I have a table with status
Contractor, Staff, Vendor, Manager
I need to create new column
That it will show the name of the person who have manager status.
Solved! Go to Solution.
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
@tebtim19 , what is logic needed ?
if(isblank([manager]), blank(), 1)
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
Not Clear,
If you are looking to match the status with another table use Merge in Power Query or create a relationship on Status.
If you want to answer your question quickly, please pose question with proper deatils and if possible share sample data.
Regards,
Manikumar
Proud to be a Super User!
Hi, okay this are the sample tables
Name | Status | Location | Gender |
Ana | Vendor | UK | Female |
Ben | Manager | UK | Male |
Jon | Staff | PHP | Male |
Kyra | Manager | UK | Female |
Linda | Staff | PHP | Female |
Gina | Manager | UAE | Female |
Porchia | Manager | PHP | Female |
Now I want to make another column which will give me the name of the status Manager which are
Ben |
Kyra |
Gina |
Prochia |
I need this column so I can eaily use this to create a slicer of option of managers
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
100 | |
78 | |
76 | |
52 |
User | Count |
---|---|
144 | |
109 | |
108 | |
88 | |
61 |