Forum Discussion

Helper I

4 years ago

Solved

Min date filter

I need get min date the filter.

shown in example

Anonymous
4 years ago
Hi SLima ,

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.

3 Replies

amitchandak
Super User
4 years ago
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
  Helper I
  4 years ago
  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
Not applicable
4 years ago
Hi SLima ,

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.

Related content