Forum Discussion
Solved
Fixing inconsistent names & missing titles
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 yo...
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.
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