I'm needing go up a management chain to find the leader of a user with 'VP' or 'Vice President' in their job title.
I've got 2 tables titled 'EnabledUsers' and 'AllUsers'.
I get the Leader's title by the following:
LeaderTitle =
Calculate(
FIRSTNONBLANK (EnabledUsers[jobTitle],1 ),
Filter (
ALL (EnabledUsers),
EnabledUsers[username] = AllUsers[leaderUserName]
)
)
If the leader's title contains 'VP', or 'Vice President', then I want to return that specific leader's Name which a column on the AllUsers table named Leader. If that leader's title does NOT contain either of those words, I want to go up a level to that leader's leader, and determine if their title contains either, and continue...
Top 1% in Freelancer.com
Hi, Greetings!
✅checked your project details:
✅Completed Time: In project deadline
We have worked on 800 + Projects. I have 6 + years of the experience in same kind of projects. I am available almost 24-7 and am very responsive.
My Portfolio Items: https://www.freelancer.com/u/schoudhary1553
Kindly contact me via chat for further details and discussion..
Thank you
Sandeep
Hello, I will be glad to assist you with that. I am an experienced Data Scientist and Data Visualization expert holding years of experience in performing Data Visualization, Data Analytics and Automation using Power BI, Tableau, Power Queries, SQL and MS Access. Lets discuss your project in detail and how I am highly suitable for this.
Hello Sir,
--
I am Anas, a data analytic with very good skills in data visualization including dashboard with both static and dynamic graphs in Power Bi, Excel and Google Data Studio. So I can achieve this task perfectly, So if you are interested in my offer, please feel free to contact me to discuss the details.
My Portfolio Items : https://www.freelancer.com/u/anasdsoul08
Regards
Anas
Hey
, I have the best terms of service with diverse multiple skills and experience in Microsoft PowerBI, Excel and Data Visualization , feel free to negotiate with me for a better deal. I will give you comprehensive, detailed, exceptional and high-quality results before your deadline
Hi,
I can do it perfectly as your request.
I look forward to discussing it specifically with you quickly.
I look forward to your reply.
Best regards to you.
3 + Years of BI Engineer with focus on Power BI Visualizations by developing highly interactive Dashboards and with Strong SQL expertise to ensure data quality in reports.
Have extensive knowledge over DAX functions to hormonize raw data
Hello,
I am a Power Bi Specialist with 2+years of experience, I can help you with this job
1- we can extract vice or vp
2- we can add column by Addcolumn function and use if formula to return name
we can have chat for the job details
Kindly, contact me for further details
Best Regards
Ahmed Adel