Forum Discussion
How to find valid values based on multiple tables
is this what you want?
Column = if(LEFT('Table'[attributes],3)="Num" && ISNUMBER('Table'[Value]),TRUE(),FALSE())
Thank you for your quick answer ryan_mayu . Unfortunately is not that easy. I am not only trying to find numbers but to associate the raw data with possibly many different tables containing a set of values, which make my data VALID or INVALID depending if the value on a specific row [Value] is found in the specified table [Data validation] (and, as next step, to be found in a specific column in that [Data validation] table, explicit in [Specific?] column.
Thank you for your go, really appreciated!
sry, not clear about your request. so your raw data only contains two columns? How you get the third column and forth column?
Nope,
My raw data (in the example provided) contains 4 columns (the formatting on the forum is not the best):
| Attributes | Value | Data validation | Specific? |The Data validation column (and, if present, the Specific? one) defines the name of the table where the valid set of values are to be found for that specific attribute.
I hope this clarifies it.
Thanks
what do you want now? check if value exists in the data validation table?
Attributes Value Data validation Specific? Valid Num1 1 TableNum TN_C1 TRUE Num2 2 TableNum TN_C1 TRUE
Num3 3 TableNum TN_C1 TRUE Text1 4 TableTxt TT_C1 FALSE Text2 5 TableTxt TT_C1 FALSE Text3 a TableTxt TT_C1 TRUE Num4 b TableNum FALSE Num5 8 TableNum TRUE Text4 9 TableTxt FALSE value 1 from TableNum, then true? value 9 not from TableTxt then FALSE?