Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I wanted to show the latest value of a table and only the 1 Month Returns value. My current measure is below and it returns me an error.
Latest = CALCULATE(SUM('Tech'[Value]),AND(FILTER(Tech,'Tech'[Date] = MAX('Tech'[Date])), FILTER(Tech,'Tech'[Metric] = "1 Month Returns")))
Consider my Table:
Date | Metric | Value |
01/01/2020 | 1 Month Returns | 20201 |
01/01/2020 | 2 Month Returns | 1213 |
01/01/2020 | 3 Month Returns | 13423 |
01/01/2020 | 4 Month Returns | 2313 |
Would just like to show the "1 Month Returns" data when I use my measure
Solved! Go to Solution.
@dragonus , Try
calculate(lastnonblankvalue(Table[Date],sum(Table([Value]))),Table[Metric] ="1 Month Returns")
or
calculate(lastnonblankvalue(Table[Date],max(Table([Value]))),Table[Metric] ="1 Month Returns")
@dragonus , Try
calculate(lastnonblankvalue(Table[Date],sum(Table([Value]))),Table[Metric] ="1 Month Returns")
or
calculate(lastnonblankvalue(Table[Date],max(Table([Value]))),Table[Metric] ="1 Month Returns")
User | Count |
---|---|
125 | |
106 | |
99 | |
63 | |
62 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |