I have a table and in the column "LatestPrice" I need to show a price only for the last day of the given period. Now all the prices are shown.
What I have done:
1) Created a measure using Lastdate function to determine the last date of the given period.
2) Created a measure to determine the latest price (the price of the last day)
Go to Solution.
@OlegV LastDate = MAXX(ALL('Brent&₽/$'),[Date])
View solution in original post
Thank you very much. It solved a problem.
Click here to read more about the December 2021 Updates!
Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.
Mark your calendars and join us for our next Power BI Dev Camp!