Forum Discussion

ccianci's avatar
ccianci
Frequent Visitor
4 years ago
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...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    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.

Anonymous's avatar
Anonymous
Not applicable
4 years ago

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.