I would like to show the last price , each Country's last price has different dates
Table has Price , Dates , Countries
Go to Solution.
@mohammedkhan add folowing as a measure
Last Price =
CALCULATE( MAX( Table[Price]),
FILTER(ALLEXCEPT( Table, Table[Countries]), Table[Dates]=MAX(Table[Dates]))
Proud to be a Super User! Appreciate your Kudos 🙂 Feel free to email me with any of your BI needs.
View solution in original post
Check out the on demand sessions that are available now!
Check out the Winners!
Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.