Forum Discussion

asafweis's avatar
asafweis
Frequent Visitor
3 years ago
Solved

get max date from before to selected date

Hi all,   I have a visual that is filtered by a slicer that selects the year and a month. This shows me a table with a list of transactions and dates. I can get the minimum date by creating a measu...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    3 years ago

    asafweis Maybe:

    Measure = MAXX(FILTER('Table',[Date] < MAX('Table'[Date]),[Date])
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
3 years ago

asafweis Maybe:

Measure = MAXX(FILTER('Table',[Date] < MAX('Table'[Date]),[Date])