Forum Discussion
Get minimum value for a specific Id
Hello,
I want to show the minimum date value for an specific Id, and this value should change on depends of the filter dates selected by the user.
I tried several solutions (index, row_number, summarized table, etc), but none of them seems to work. I think the main problem is the dynamic filter, so I need to recalculate the minimum value each time the user change the filter. So in the attached screenshot each filter is a particular selection made by the user and the result set that should retrieve.
Any ideas?
Thank you!
I think a simple MEASURE like
=MIN(TABLENAME[Date]) should work here
May be i am missing something
4 Replies
robertspot,
Zubair_Muhammad's DAX works, but it seems that there are some issues with your desired result of first two filters. Please check the following screenshots.
No filter & filter3filter1filter2
Regards,
LydiaHi Anonymous,
You're right Zubair_Muhammad 's DAX works, I just was dragging and additional column and the aggregation didn't seems correct. But I've run some tests and works fine.
Thank you both
I think a simple MEASURE like
=MIN(TABLENAME[Date]) should work here
May be i am missing something
Hi Zubair_Muhammad,
Thanks for your reply.
I’m afraid it won’t work because I need the min date, but for each ID. That means, if no filter is applied the results would be:
- ID: 1; Date: 01/01/2018
- ID: 2; Date: 02/01/2018
- ID: 3; Date: 04/01/2018
Regards
