I have 12 dates, and each date has corresponding value of Returns.
I want a measure that will get the Returns of the first date and then use that value on all other dates.
Go to Solution.
Please try this measure:
first date return =
SELECTEDVALUE ( Table[Returns] ),
Table[Dates] = CALCULATE ( MIN ( Table[Dates] ), ALL ( Table ) )
View solution in original post
Join us in the third Triple A event!
It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.
Make sure you didn't miss any of the things that happened in the community in January!