Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

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

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

 

Need Help

2 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    6 years ago

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

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Thanks Greg!

       

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

      That worked