Forum Discussion
Help with Vlookup using same column for search value and column value
Hi everyone, I cant get my head around this problem in Power BI. I´m adding a new column to my table and want to check lookup if the same ID has value in both the column "F" and "L", but on diffe...
Anonymous
Please try
= IF ( TableName[ID] IN VALUES ( TableName[L] ) && TableName[ID] IN VALUES ( TableName[F] ), 1, 0 )Anonymous
Please use= VAR CurrentIDTable = CALCULATETABLE ( TableName, ALLEXCEPT ( TableName, TableName[ID] ) ) VAR FValue = SUMX ( CurrentIDTable, TableName[F] ) VAR LValue = SUMX ( CurrentIDTable, TableName[L] ) RETURN IF ( FValue > 0 && LValue > 0, 1, 0 )
Sorry, misstake from me
tamerj1
Community Champion
Community ChampionAnonymous
Please try
=
IF (
TableName[ID]
IN VALUES ( TableName[L] )
&& TableName[ID] IN VALUES ( TableName[F] ),
1,
0
)Hi! Thanks, but unfortunalety it doesn´t work. One thing that might add more complexity is that a ID can have multiple rows with values in column "F" and "L", but shouldn affect your code above?
edit: Is the problem related to the value is not 1 in both "F" and "L" on the same row?
ID F L Both F and L 1 1 0 1 1 0 1 1 1 1 0 1 1 0 1 1 1 0 1 1 1 0 1 1 - tamerj1
Anonymous
This is the result I get out of this codeAm I missing something?
Hi,
No, it looks correct! Can there be some issue with the format of my table? The columns "F" and "L" are calculated columns in the datatype and format "Whole number". The ID columns is not calculated but has the same format and datatype.