Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I have a formula that accurately looks up the value of [TYPE] for an [ID] where Date = [Last Event Date]:
Last Type = (LOOKUPVALUE('Data'[TYPE],'Data'[ID],VALUES('Data'[ID]), 'Data'[Date], [Last Event Date]))
My question is how to alter this formula for cases where there are multiple rows with the same ID and Date but different values of TYPE?
Thanks for your help.
Hey,
not sure if you want to create a calculated column or a measure, but basically you can try something like this (for a measure):
var currentID = CALCULATE(FIRSTNONBLANK('Data'[ID],1)) return CALCULATE( FIRSTNONBLANK('Data'[TYPE],1) ,FILTER(ALL('Data'[ID],'Data'[Date]) ,'Data'[ID] = currentID && 'Data'[Date] = [Last Event Date] ) )
Hopefully this is what you are looking for
Regards,
Tom
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
94 | |
81 | |
66 | |
58 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |