I can't work out how to return the latest text value in my table depending on a date range. So my table is showing PPE concernes from providers, they will not anser this question each time just complete if the answer changes - I want to show the last text input
|Provider name||Date||Answer (Yes/No)|
if date range selected is 01/05/2020 to 05/05/2020 then Provder A = Yes, B = Yes, C = No.
If date range selected is 01/05/2020 to 03/05/2020 then Provider A = Yes, B = No, C = Yes.
If date range selected is 01/05/2020 to 01/05/2020 then Provider A = Yes, B = "Blank/Not completed", C = No
Can anyone help me please......?
Solved! Go to Solution.
I believe you want Lookup Min/Max: https://community.powerbi.com/t5/Quick-Measures-Gallery/Lookup-Min-Max/m-p/985814#M434
@Cbutler That's the Lookup Min/Max pattern I sent, https://community.powerbi.com/t5/Quick-Measures-Gallery/Lookup-Min-Max/m-p/985814#M434
Check out new user group experience and if you are a leader please create your group!
On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks
Check out how to claim yours today!