Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
RaffiKouzoudj
Helper III
Helper III

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
1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@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

View solution in original post

1 REPLY 1
amitchandak
Super User
Super User

@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

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.