topic Re: Min date filter in DAX Commands and Tips

Min date filter

SLima — Mon, 06 Dec 2021 14:07:36 GMT

I need get min date the filter.

shown in example

amitchandak — Mon, 06 Dec 2021 14:36:51 GMT

SLima , if you have slicer, you can create var in measure like given below

measure =
var _max = maxx(allselected('Date'),'Date'[Date])
var _min = minx(allselected('Date'),'Date'[Date])

return

<Code>

SLima — Mon, 06 Dec 2021 14:51:12 GMT

No, I need it to return the first date of the selected month.

filter = 01/10/2021 - 21/11/2021

Return = 01/10/2021

filter = 04/10/2021 - 21/11/2021

Return = 01/10/2021

filter = 20/10/2021 - 21/11/2021

Return = 01/10/2021

filter = 30/11/2021 - 21/12/2021

Return = 01/11/2021

Anonymous — Thu, 09 Dec 2021 02:52:33 GMT

You can create a column like below:

Min Date= EOMONTH(Table[Date],-1)+1

Hope it helps,

Community Support Team _ Caitlyn

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