Solved: Date format error

Anonymous · ‎07-06-2020

I have created the below DAX;

New Downloads Title = var latest = LASTDATE('iOS - All App Units'[Date]) return "Total Downloads from " & latest

If i do this in it's own dax it shows the below;

iOS Latest Date = LASTDATE('iOS - All App Units'[Date])

As you can see, I would like it in GMT format no the output from the first DAX statment.

Thanks

Greg_Deckler · ‎07-06-2020

@Anonymous - Try using the FORMAT command to wrap your LASTDATE function.

Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!: DAX For Humans

DAX is easy, CALCULATE makes DAX hard...

Greg_Deckler · ‎07-06-2020

@Anonymous - Try using the FORMAT command to wrap your LASTDATE function.

Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!: DAX For Humans

DAX is easy, CALCULATE makes DAX hard...

Anonymous · ‎07-06-2020

Thanks Greg!

New Downloads Title =
var latest = FORMAT(LASTDATE('iOS - All App Units'[Date]),"DD/MM/YY")
return
"Total Downloads from " & latest

That worked

Date format error