Performing Date format dd/mm/yyyy in Measure

[Anonymous]

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") 

please help me.

Thanks

Godasu

[Anonymous]

Measure = FORMAT(VALUES('date'[date]);"dd/mm/yyyy")

This works for me. The only difference i can spot is the ' ' around date and the ; instead of ,
You might want to try it.

[Anonymous]

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

[Wayfarer]

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/?