Forum Discussion
Solved
Latest value before a selected date
I'm having trouble getting this to work in a DAX measure. User picks a single date For each CustomerID find their latest permissiontype that is before that time. This should be in an intermedia...
Works like a charm, but only when the Calendar Table and the Permission Table aren't linked with a relationship.
I've tried adding some removefilters functions, but couldn't quite get it to work, appears to only give me the MAX value for a single CustomerID, i presume number 7.
Any ideas?
yes, it will work if there is no connection
or need to add two calendars
Yeah I know, but I do want the connection active for my other visuals / calculations.
You think its possible to alter the measures to allow so without needing a second date table?
