Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
Hello all,
I have two issues I'm hoping you can help me with. I'm fairly new to Power BI & Power Query and i'm working on a PBI report comparing joiners vs leavers over the last x years. For your reference, the raw data file actually uses the values "joiners" and "leavers":
Thank you for your help.
Solved! Go to Solution.
Hi @ccianci ,
You may add a new column:
Filled Title =
var _title= CALCULATE(MAX('Table'[Title]),ALLEXCEPT('Table','Table'[Email]))
return IF([Title]=BLANK(),_title,[Title])
Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @ccianci ,
You may add a new column:
Filled Title =
var _title= CALCULATE(MAX('Table'[Title]),ALLEXCEPT('Table','Table'[Email]))
return IF([Title]=BLANK(),_title,[Title])
Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thank you both. Here's a sample data (cleaned for privacy) of what I'm talking about:
Item | Full Name | Name | Title | Start Date | Leaving Date | |
Joiner | Doe, John | jdoe@email.com | Vice President | 2022-05-16 | ||
Joiner | Low, Karen | klow@email.com | Consultant | 2022-03-21 | ||
Leaver | Karen Low | klow@email.com | 2022-05-15 |
First issue: Leaver title is missing (line 4) but since that same employee joined this year (line 3). Is there a way to do a search in Power Query (or dax) to fill in that title? If the search returns nothing, then leave the title blank.
Second issue: cancel this one - i figured out a solution using Power Query
Hi @ccianci ,
Any updates?
As @lbendlin mentioned , the information you have provided is not making the problem clear to us, please provide me with more details about your table and your problem or share me with your pbix file after removing sensitive data.
Refer to:
How to provide sample data in the Power BI Forum - Microsoft Power BI Community
Best Regards,
Eyelyn Qin
Please provide sanitized sample data that fully covers your issue. If you paste the data into a table in your post or use one of the file services it will be easier to assist you. I cannot use screenshots of your source data.
Please show the expected outcome based on the sample data you provided. Screenshots of the expected outcome are ok.
https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
59 | |
53 | |
26 | |
16 | |
10 |