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