Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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!
Solved! Go to Solution.
I think a simple MEASURE like
=MIN(TABLENAME[Date]) should work here
May be i am missing something
@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 & filter3
filter1
filter2
Regards,
Lydia
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
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:
Regards
User | Count |
---|---|
119 | |
65 | |
65 | |
56 | |
50 |
User | Count |
---|---|
177 | |
84 | |
70 | |
64 | |
54 |