Forum Discussion

sergiod04's avatar
sergiod04
Frequent Visitor
6 years ago
Solved

ENDOFMONTH + Most Recent Date

Hello,    I have a table which brings back values for the last date of the month and the most recent date available in the data set. For example, if the most recent date in the data set is 8/10/202...
Need Help
  • amitchandak's avatar
    amitchandak
    6 years ago

    sergiod04  Try like

    Measure = CALCULATE (lastnonblankvalue(DATE_TABLE[Date],SUM(VALUE))), based on grouping it will choose date. Take month year on axis/row/column

amitchandak's avatar
amitchandak
Super User
6 years ago

sergiod04  Try like

Measure = CALCULATE (lastnonblankvalue(DATE_TABLE[Date],SUM(VALUE))), based on grouping it will choose date. Take month year on axis/row/column

sergiod04's avatar
sergiod04
Frequent Visitor
6 years ago

This will work! thank you!