Forum Discussion

GerbenvdHazel's avatar
GerbenvdHazel
Icon for Helper I rankHelper I
6 years ago

Look up value between two dates from different table

Good day, I have two tables. One with trajectories with an end date. The second table concerns relationships where persons working with a start and end date. The dates are not match exactly....
Need Help
Tips and Tricks
GerbenvdHazel's avatar
GerbenvdHazel
Icon for Helper I rankHelper I
6 years ago

Thanks for helping. 
I edit the post with a link to the file.

 

Regards, Gerben

Syndicate_Admin's avatar
Syndicate_Admin
Icon for Administrator rankAdministrator
4 years ago

Hello

I have a question that I do not know how to solve. I have an excel with information of: several vehicles of a company (column with registrations) with an entry date (column "phase in") and another column of output "phase out". I also have another column "Ownership" that has to have the filter "Owned" which is the data that I want to know happens to know the fleet owned by the company.

I wanted to know what fleet I own every month in fiscal year. I understand that with a "DAX" you could? with which exactly??

I have the excel but I can't attach it, if necessary I can send it.

Thanks in advance.