Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Vlookup - value replace

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).   ...
Need Help
  • amitchandak's avatar
    amitchandak
    5 years ago

    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

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

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's avatar
Anonymous
Not applicable
5 years ago

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