Call a measure in another table to get that value by date for each user

[AndrewWstry]

Hello,

I am having trouble trying to pull in a measure for MIN dates into another table to perform a calculation based on that date. When I try to pull in the column from the other table is defaulting to the earliest date for every single row. These tables are indirectly related by user ID to a UserInfo table. Any help is very appreciated!

First punch in time measure in the timecard table

When I type in First punch in time (M) in the Job History table its all defaulted to 1/9/2023 for every user

I am trying to determine date of operation based on the First Punch In time measure example:

Sort Date = IF('JobHistory'[Sort Date] < [First Punch In Time (M)], 'JobHistory'[sort date] +1 , 'JobHistory'[sort date])

[Anonymous]

Hi @AndrewWstry ,

If I understand correctly, it seems that it involves two tables: timecard table and Job History table. The calculated column [First Punch In Time (M)] is the MIN data for per user in the timecard table. And you want to compare the [Sort Date] in the table 'JobHistory' with [First Punch In Time (M)], if 'JobHistory'[Sort Date] is less than  [First Punch In Time (M)], then 'JobHistory'[Sort Date]+1 else 'JobHistory'[Sort Date]. Am I right?

Is there any relationship created between the timecard table and Job History table? If yes, please provide the relation info. The final expected result is a calculated column or measure? And could you please provide some raw data in the tables (exclude sensitive data) with Text format and your expected result with backend logic and special examples? It would be helpful to find out the solution. You can refer the following links to share the required info:

How to provide sample data in the Power BI Forum

And It is better if you can share a simplified pbix file. You can refer the following link to upload the file to the community. Thank you.

How to upload PBI in Community

Best Regards