Forum Discussion
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).
below highlighted color is blank and vlookup value replace to master file.
Master tbl :
Vlookup tbl:
Thanks,
KV's
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
2 Replies
- amitchandak
Super User
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
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