Forum Discussion

robertspot's avatar
robertspot
New Member
8 years ago
Solved

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...
Need Help
  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    8 years ago

    robertspot

     

    I think a simple MEASURE like

     

    =MIN(TABLENAME[Date])   should work here

     

    May be i am missing something

     

     

Anonymous's avatar
Anonymous
Not applicable
8 years ago

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's avatar
    robertspot
    New Member
    8 years ago

    Hi 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