Forum Discussion
Lookup Date in one table, return value from another; Direct Import
If you are looking for a measure DAX syntax, add this measure to your Expense Data table.
Total Hours by Type Absence = var _curValue = CALCULATE( SUM('Time Data'[ Hours ]), FILTER( 'Time Data', 'Time Data'[EmpID] = SELECTEDVALUE('Expense Data'[EmpID]) && 'Time Data'[Date] = SELECTEDVALUE('Expense Data'[Date]) && 'Time Data'[ Type ] = " Absence" )) RETURN IF ( HASONEVALUE('Expense Data'[EmpID]) && HASONEVALUE('Expense Data'[Date]) , IF (ISBlank(_curValue), 0, _curValue) , BLANK())Adjust the formula, I see / got spaces when I copy pasted your sample data.
Hope it helps!
If you are looking for a measure DAX syntax, add this measure to your Expense Data table.
Total Hours by Type Absence =
var _curValue = CALCULATE( SUM('Time Data'[ Hours ]),
FILTER( 'Time Data',
'Time Data'[EmpID] = SELECTEDVALUE('Expense Data'[EmpID])
&& 'Time Data'[Date] = SELECTEDVALUE('Expense Data'[Date])
&& 'Time Data'[ Type ] = " Absence"
))
RETURN IF ( HASONEVALUE('Expense Data'[EmpID]) && HASONEVALUE('Expense Data'[Date])
, IF (ISBlank(_curValue), 0, _curValue)
, BLANK())
Adjust the formula, I see / got spaces when I copy pasted your sample data.
Hope it helps!
Thank you so much for the help and replay. Unfortunately, results are blank (even for days when I know there should be Absence time). Any thoughts?
Share the data where and when it happens, we can take a look at it!
(Remove sensitive info)
Easier said than done -- both source tables are Direct Query connections to SQL tables with millions and millions of rows. I added the column with your "formula", updating for my data sources (and double checked that I got it correct), but the whole column is blank.
