Get minimum value for a specific Id

[robertspot]

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!

[v-yuezhe-msft]

@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,
Lydia

[robertspot]

Hi @v-yuezhe-msft,

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

[Zubair_Muhammad · Accepted solution]

@robertspot

I think a simple MEASURE like

=MIN(TABLENAME[Date])   should work here

May be i am missing something

[robertspot]

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