Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
6 years ago

To **bleep** With TOTALMTD

It's a little known fact that there are actually five, not four, Horsemen of the Apocalypse, their names being: Death Famine War Plague Insanity (AKA - DAX Time Intelligence Functions) ...
Time Intelligence
gdrum's avatar
gdrum
Frequent Visitor
2 years ago

Greg_Deckler hi. very helpful for me with direct query. So why not use Today() instead of MAX for YTD Ending. 

VAR __Date = Date(YEAR(TODAY()),MONTH(TODAY()),DAY(TODAY()))
  • Greg_Deckler's avatar
    Greg_Deckler
    Icon for Community Champion rankCommunity Champion
    2 years ago

    gdrum Perfectly acceptable to use TODAY as well. Just depends on the specifics of the data model and requirements.