How to Tie Two Tables Together?

[PatrickMcLeanGL]

I have a dashboard that takes values from "Current Data" table, but I also want to include a card value from my "ADP Hours" table that sums up the total hours in that table for the date range chosen. Right now my date slicer doesn't affect the value from that Sum Of Hours card.

[PatrickMcLeanGL]

That worked, thank you muchly!

[ajaybabuinturi · Accepted solution]

Hi @PatrickMcLeanGL,

I belive your question is, are we restric the data with same date slicer/filter for both column and card charts.
Yes, we can achive the results by creating relationship between "Current Data" and "ADP Hours" tables by using "Date" column.

If the dates are not unique, create separate "Date/Calander" table and then create a relationship between "Current Data", "ADP Hours" and "Date/Calander" table by using "Date" column

Thanks,