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 measure like MIN(<date column>). This would return a date that is the first date within the month that is selected in the slicer. 

How can I return the next previous date so that I am displaying the maximum date of all the dates prior to the ones filtered by the slicer?

 

Thank you

1 Reply

  • Greg_Deckler's avatar
    Greg_Deckler
    Icon for Community Champion rankCommunity Champion

    asafweis Maybe:

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