topic Re: Get User selected dates in date range in DAX Commands and Tips

Get User selected dates in date range

varshajain — Thu, 18 Aug 2022 20:16:01 GMT

I have a DAX function to retrieve teh date range that user has selected

Dates = var _max = maxx(allselected('Candidates'[CreateDate]),'Candidates'[CreateDate])

var _min = minx(allselected('Candidates'[CreateDate]),'Candidates'[CreateDate])

return _min

User selected date is

I'd like to get 6/1/2022 and 7/31/2022 in my DAX function. However, I notice that with the above DAX I am getting 6/4/2022 as the minimum as the earliest data in my table for this range is dated as 6/4/2022.

Is there a way to get 6/1/2022 and 7/31/2022 or whatever user selects in that date filter?

Thanks!

Re: Get User selected dates in date range

daXtreme — Thu, 18 Aug 2022 20:49:57 GMT

ALLSELECTED is not the right function to use in this context since there's no iteration going on in the visual. This is why it returns the whole column. It is the most complex function in whole DAX and it should be well understood before one can use it. If one doesn't, then please don't. In yur case you should put the whole table as the first argument under min/max to get what you want.

Re: Get User selected dates in date range

varshajain — Thu, 18 Aug 2022 20:56:41 GMT

I updated my function to this

Dates = var _max = max('Candidates'[CreateDate])

var _min = min('Candidates'[CreateDate])

return _min

However, I still the same issue. My expected result is to see 6/1/2022 but it shows 6/4/2022 which happens to be the earliest date for data in table. Also, the _max is returning 7/30/2022 as opposed to 7/31/2022.

Re: Get User selected dates in date range

Anonymous — Tue, 23 Aug 2022 08:23:29 GMT

Hi varshajain ,

Here are the steps you can follow：

1. Create measure.

mindate = var _minx=MINX(ALLSELECTED('Table'),[Date]) var _maxx=MAXX(ALLSELECTED('Table'),[Date]) return DATE(YEAR(_minx),MONTH(_minx),1)

2. Result:

If you need pbix, please click here.

Get User selected dates in date range.pbix

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

Re: Get User selected dates in date range

varshajain — Tue, 23 Aug 2022 12:37:17 GMT

Thank You for your response. I also did something similar to solve my issue by constructing the date based on month and year

Re: Get User selected dates in date range

Anonymous — Mon, 25 Sep 2023 09:12:26 GMT

have you found the solution, I have the same problem