Forum Discussion

shuhn1229's avatar
shuhn1229
Resolver I
3 years ago
Solved

Combining First Non Blank with Filter

Hi all,   I have two tables, lets call them A and B. Table A is a key column and is used to map naming conventions to B when a user uses an inappropriate name. However, this mapping can be differen...
Need Help
  • Ahmedx's avatar
    Ahmedx
    3 years ago

    pls try this

     

     

    Column = 

 COALESCE(
     CONVERT(
         CALCULATE(MAX('TableA'[Key]), FILTER(ALL(TableA),TableA[Name]='TableB'[Name]&&TableA[ID]='TableB'[D])),STRING),
     [Name])

     

     

Ahmedx's avatar
Ahmedx
Super User
3 years ago

pls try this

 

 

Column = 

 COALESCE(
     CONVERT(
         CALCULATE(MAX('TableA'[Key]), FILTER(ALL(TableA),TableA[Name]='TableB'[Name]&&TableA[ID]='TableB'[D])),STRING),
     [Name])