Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
i Have a date colum as format as mm/dd/yyy but i need to create a measure as dd/mm/yyyy
i wrote a dax
Measure = FORMAT(VALUES('date'[date]);"dd/mm/yyyy") thsi forula working fine but only came single date.. but i need to display all dates
note : in my database date field having column nota measure
Thanks
Godasu
What data type is your measure and 'date'[date]? If they're actually dates and not text, you should be able to set the data type in the Modeling tab. I've done this instead of using FORMAT DAX code.
If it's type Date, I suggest setting Format to d/MM/yyyy. This would show 27/11/2019. If you set it to *d/MM/yyyy it will probably show 11/27/2019 when report is published online. Do you specifically need dd/ instead of d/?