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...
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?
or you can create an inactive relationship between them and activate it with USERELATIONSHIP where you need it