Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
I have a simple table with three columns of value:
Investment Product, Value Date, Unit Value
I want to use the Unit Value in a measure calculation, but it must give me the unit rate with the latest date.
How do I do that?
SOLVED: I found Lookup.... and LastDate....
@hildasteyn I hope this help you
rate by latest date =
User | Count |
---|---|
83 | |
75 | |
71 | |
42 | |
36 |
User | Count |
---|---|
114 | |
56 | |
52 | |
43 | |
42 |