Re: DAX to return ISO Date Format

smpa01 · ‎09-09-2022

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

Does DAX have anything similar at all? (not looking for a PQ solution).

I tried following

Thank you in advance.

Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

My custom visualization projects

Plotting Live Sound: Viz1

Beautiful News:Viz1, Viz2, Viz3

Visual Capitalist: Working Hrs

Others:Easing Graph, Animated Calendar

Watsky · ‎09-09-2022

Hey @smpa01,

How about ...

NewDate = FORMAT(UTCNOW(),"YYYY-MM-DDTHH.mm.ss.SSSZ")

or you could add it to the format section under Column tools.

Did my answer(s) help you? Give it a kudos by clicking the Thumbs Up!
Did my post answer your question(s)? Mark my post as a solution. This will help others find the solution.

Proud to be a Super User!

smpa01 · ‎09-09-2022

@Watsky thanks for this.

But it does not seem to spit out milliseconds (I think)

Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

My custom visualization projects

Plotting Live Sound: Viz1

Beautiful News:Viz1, Viz2, Viz3

Visual Capitalist: Working Hrs

Others:Easing Graph, Animated Calendar

Watsky · ‎09-09-2022

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.

Did my answer(s) help you? Give it a kudos by clicking the Thumbs Up!
Did my post answer your question(s)? Mark my post as a solution. This will help others find the solution.

Proud to be a Super User!