Return only most recent Data

Question

I need to pull only the most recent "Rooms Revenue" value from the table below, according to "RR_CreatedOn" for both DataTypes: "Forecast" and "Budget". I have already written a measure that calculates the most recent "RR_CreatedOn" value. But i have had no successes in pulling the correct RoomsRevenue value for the most recent "RR_CreatedOn" date. Please help.

Recent RR-CreatedOn = Calculate(Max(Fact_RoomsRevenue[RR_CreatedOn]))

*this measure is accurate*

itsme · Accepted Answer

Try this:&nbsp;Recent&nbsp;RR-CreatedOn&nbsp;=CALCULATE&nbsp;(&nbsp;&nbsp;&nbsp;&nbsp;SUM&nbsp;(&nbsp;'Fact_RoomsRevenue'[Rooms&nbsp;Revenue]&nbsp;),&nbsp;&nbsp;&nbsp;&nbsp;FILTER&nbsp;(&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;ALL&nbsp;(&nbsp;'Fact_RoomsRevenue'&nbsp;),&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;(&nbsp;'Fact_RoomsRevenue'[RR_CreatedOn]&nbsp;)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=&nbsp;MAX&nbsp;(&nbsp;'Fact_RoomsRevenue'[RR_CreatedOn]&nbsp;)&nbsp;&nbsp;&nbsp;&nbsp;))

Forum Discussion

Return only most recent Data

1 Reply

Related content

Most Recent Transaction

Find Most Recent Date Relative to another Date Column in Power Query

Return the last 3 Most recent dates.

Return correct status according to most recent entry.

Measure returning incorrect value