Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi,
Need help as per below table information. i have to pick the latest value (%) based on the end date . some of the end dates are availables with blank though i have to refer the value with latest value showing up in below table.
89% have to show in card vix.
Please suggest.
End Date Completion
4/12/2019 | 100% |
6/22/2019 | 90% |
6/20/2021 | 89% |
12/13/2021 |
Solved! Go to Solution.
Hi @rajendraongole1 ,
Is this what you want? Please refer to my .pbix file.
Best regards,
Lionel Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @rajendraongole1 ,
Is this what you want? Please refer to my .pbix file.
Best regards,
Lionel Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@rajendraongole1 , Try a new measure. If Completion is a measure
lastnonblankvalue(table[End Date],[Completion])
if it is a column
lastnonblankvalue(table[End Date],max(Table[Completion]))
thanks for your reply amit,
I have tried both the options , it is not picking up the right value. as in last end date we have blank in % completion so reported with 0. but expected to pick the value of 89% which is other than blank information.
any suggestions. pls
As per the end date, it has to take the end date before value in completion.
Pls suggest.
User | Count |
---|---|
130 | |
108 | |
101 | |
67 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |