Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
Anonymous
Not applicable

Date format error

I have created the below DAX; 

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

Griffy_0-1594040378976.png

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

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

Griffy_1-1594040392329.png

 

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

 

 

Thanks

 

1 ACCEPTED SOLUTION
Greg_Deckler
Community Champion
Community Champion

@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...

View solution in original post

2 REPLIES 2
Greg_Deckler
Community Champion
Community Champion

@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
Not applicable

Thanks Greg!

 

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

That worked 

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors