DAX Date format

[RaffiKouzoudj]

Dear all,

I am using the below measure to display the filtered dates on my report. Without formatting the dates the values are returning the right dates. However, when I added the FORMAT functionality wrong dates are getting displayed, not the ones that are filtered. Any help on how to format dates in measure? Thank You

From_To_Date =

var _max = maxx(allselected('Dates'), FORMAT(Dates[Date],"dd-mmm-yyyy"))

var _min = minx(allselected('Dates'), FORMAT(Dates[Date],"dd-mmm-yyyy"))

return

"From " & _min & " to " & _max

[amitchandak · Accepted solution]

@RaffiKouzoudj , First take Min/Max and then format. Because if you take it before it going to be text Min/Max

From_To_Date =
var _max = FORMAT(maxx(allselected('Dates'), Dates[Date]),"dd-mmm-yyyy")
var _min = FORMAT(minx(allselected('Dates'), Dates[Date]),"dd-mmm-yyyy")
return
"From " & _min & " to " & _max