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 bel...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    6 years ago

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

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