Vlookup - value replace

[Anonymous]

Hi Team,

DAX/M Query

I have master data table in pbi file and vlookup table if master data value is null then i need to refer to vlookup table based on combine column (combine column A+B+C).

below highlighted color is blank and vlookup value replace to master file.

Master tbl :

Vlookup tbl:

Thanks,

KV's

[amitchandak · Accepted solution]

@Anonymous , In Dax you can create three columns like

new value 1 =
var _max = maxx(filter(vlookup(Table, vlookup[ID] = master[ID])), [Value1])
return
if(isblank([Value1]), _max, [Value1])

Same for value 2, value 3

[Anonymous]

Hi @amitchandak ,

Can you clear below one,

below one got error  ->

Value_V1 =
var _length= MAXX(FILTER('Referennce sheet'('Referennce sheet'[combine]='Master'[Combine_Tbl])),[Value1])
return
IF(ISBLANK([Value1]),_length,[V1])

Thanks,

KV's