Forum Discussion
AlexaderMilland
Helper III
Helper IIILatest 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...
Ahmedx
Super User
Super UserBased on your description, I created data to reproduce your scenario. The pbix file is attached in the end.
https://1drv.ms/u/s!AiUZ0Ws7G26RiWuJZByhXXf8ZqfE?e=R48eEb
AlexaderMillandHelper III
Helper IIIYeah but that is only the intermediate table, not the one I actually want to be the output.
I want the output to be the distinctcount of customerid per permissiontype of that table you just created.
So I would need the above measure to be an calculatetable in the DAX measure and then some final measure function that can calculate the number of customerIDs per type.
The final output on the canvas would not contain the CustomerID