Last seen: Jul 7, 2026
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!
I found a post from 2019 on this very error message. The solution provided there is to wrap the true/false bit in the FILTER function. Added su...