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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

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
Super User
Super User

@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!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...

View solution in original post

2 REPLIES 2
Greg_Deckler
Super User
Super User

@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!:
The Definitive Guide to Power Query (M)

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
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.