Forum Discussion

RaffiKouzoudj's avatar
RaffiKouzoudj
Helper III
5 years ago
Solved

DAX Date format

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
Need Help
  • amitchandak's avatar
    amitchandak
    5 years ago

    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

1 Reply

  • amitchandak's avatar
    amitchandak
    Super User
    5 years ago

    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