Forum Discussion

SLima's avatar
SLima
Helper I
4 years ago
Solved

Min date filter

    I need get min date the filter.  shown in example  
  • Anonymous's avatar
    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.

amitchandak's avatar
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's avatar
    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