Forum Discussion
Solved
Lookup value not showing correct data
Hello All, I am trying to get the list name from other table called List, which contains word (ex Petrol ) and against that expense name (ex: Petrol = Vehicle Maintanance). In my main table t...
Hi, nagaraj007
Since there is more than one matching value in your data, you need to modify the code.
Like this:
Column = MAXX ( TOPN ( 1, FILTER ( ADDCOLUMNS ( tblLookUp, "pos", SEARCH ( tblLookUp[List], PettyCash[Description], 1, 0 ) ), [pos] > 0 ), [pos], ASC ), tblLookUp[Expenses] )Did I answer your question ? Please mark my reply as solution. Thank you very much.
If not, please feel free to ask me.
Best Regards,Community Support Team _ Janey
thank you very much v-janeyg-msft got the required output...
Hi, nagaraj007
Since there is more than one matching value in your data, you need to modify the code.
Like this:
Column =
MAXX (
TOPN (
1,
FILTER (
ADDCOLUMNS (
tblLookUp,
"pos", SEARCH ( tblLookUp[List], PettyCash[Description], 1, 0 )
),
[pos] > 0
),
[pos], ASC
),
tblLookUp[Expenses]
)
Did I answer your question ? Please mark my reply as solution. Thank you very much.
If not, please feel free to ask me.
Best Regards,
Community Support Team _ Janey
thank you very much v-janeyg-msft got the required output...