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.
Learn how to create your own user groups today!
Click here to read more about the November 2021 Updates!
Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.