Last seen: Aug 26, 2025
Thanks for your patience with me perhaps being slow in understanding. But, when I look at the file you uploaded none of the events in the first sheet ...
So I assume you have already connected to both Table1 and Table2. Then, in the Table1 query, you add a Custom column with the formula: =Table2 N...
That's just a few extra steps and renaming the columns (didn't do that last step, though). See attached.
Sure, you can create a combined table by using VLOOKUP and then make sure that every table has the employee code and the department code in it based o...
The attached file contains what could be the beginning of a solution, though it's based on a the first 143 rows only. It would work the same on 2.5K r...
See attached! The problem is that you can't filter from the SickDay table 'up-stream' towards the Employee/Department table to calculate the number...
Thanks Paul! I remember working on this with you earlier but find it difficult to see what you mean. I tried changing a few end dates to be the same a...
There is no attachment. Please try again and don't forget to press "Start upload" before you submit your reply.
Perhaps the attached file does what you asked for. Use 'Event no year' and 'Year' as row labels in the PT in stead of 'Event'. That will group the PT ...
Please upload a file with some example events/dates and the formula you mentioned. It's otherwise difficult to determine what's right or wrong. The fo...
Thx to @Velouria!! I've added the time intelligent solution to the file.
That's a setting in Query Options. Make sure you have M-intelligence enabled. An a Mac right now and can't get to the PC setting as Mac doesn't have t...
Now, I must admit that I'm not at all comfortable explaining DAX measures. Although, the attached workbook does what you need (I believe) by adding th...
Glad it worked. Can't tell why my original solution doesn't work for you. Sorry!