DAX to return ISO Date Format

Question

I can run this js on a browser console that returns the timestamp including milliseconds
&nbsp;

&nbsp;
Does DAX have anything similar at all? (not looking for a PQ solution).
I tried following

Thank you in advance.
&nbsp;
&nbsp;

watsky · Answer

Hey&nbsp;smpa01,
How about ...&nbsp;
NewDate = FORMAT(UTCNOW(),"YYYY-MM-DDTHH.mm.ss.SSSZ")
or you could add it to the format section under Column tools.&nbsp;&nbsp;

&nbsp;

anonymous · Answer

Please check this&nbsp;https://community.powerbi.com/t5/Desktop/Support-for-ISO-8601-Date-Time-format-DateTime-ToString-quot-O/m-p/309187

smpa01 · Answer

Watsky&nbsp; thanks for this.
&nbsp;
But it does not seem to spit out milliseconds (I think)
&nbsp;

&nbsp;
&nbsp;

watsky · Answer

Yeah 😞 for whatever reason Power BI refuses to use the miliseconds (fractional seconds) instead rounds up the second. I can't see any way to do this without working in PQ or having the timestamp brought in as text.

Forum Discussion

DAX to return ISO Date Format

4 Replies

Related content

Date Different return wrong value

DAX Query Format Date

Date format issue

FORMAT() returns Month Number

Date formatting