Extract Latest Month from a Relative Date Slicer to use in a measure

[ajay_gajree]

Hi All
Can you extract the max month (last day) from a relative date slicer?

So if my relative date slicer shows the date range

01/04/2019 to 31/07/2019

Can I extract 31/07/2019 using DAX?

[Tan]

EndofMonth = EOMONTH(MIN([Date]),1)

[PattemManohar · Accepted solution]

@ajay_gajree Please try these measures

Selected Date Min = MINX(ALLSELECTED('Date'[Date]),[Date])

Selected Date Max = MAXX(ALLSELECTED('Date'[Date]),[Date])

[alpeshpowerbi]

what if we only want the minimum date to be fetched from slicer , but the same date should not be filtered in Matrix for a different visual on same page

[vik0810]

HI @ajay_gajree,

yes, with MAX Function on your date column, that is filtered by the Slicer. MAX(Table[date]) will return 31/07/2019 in your example.