Forum Discussion
Data filtering by table values
You can add a calculated column to your DataTbl table which tests for the existance of the same timestamp in the SecondTable
and returns the Parameter Value if it finds on and 0 if it doesn't find a match.
I notice you SUM your ParameterValues, do you want to SUM if there are multiple matches?
New Column = IF( RELATED(SecondTable[TimeStamp])<>BLANK(), 'DataTbl'[Parameter], 0 )
You can add a calculated column to your DataTbl table which tests for the existance of the same timestamp in the SecondTable
and returns the Parameter Value if it finds on and 0 if it doesn't find a match.
I notice you SUM your ParameterValues, do you want to SUM if there are multiple matches?
New Column = IF(
RELATED(SecondTable[TimeStamp])<>BLANK(),
'DataTbl'[Parameter],
0
)
Hi Phil,
I would like to add a column not to the DataTbl but to the one_column TimeStampTable.
If a value is found in the DataTable then copy it otherwise put zero.
The best should be not to manage one column for each parameter but all the DataTable parameter_columns at once.
p.s I used SUM as aggregate function, as there is a unique timestamp value, also VALUES can be used.
.