Forum Discussion
Helper IIIDAX help - Get latest value for each ID
Hi,
This one works
=if(HASONEFILTER(Table1[Name]),LOOKUPVALUE(Table1[Value],Table1[Date],[Latest value],Table1[Name],VALUES(Table1[Name])),BLANK())
Hope this helps.
Hello sir!
Last time when I used your function due to my case i was using it by mixing with my own function.
This time i need exactly what is in here, but when i used it i am not being able to handle few issues.
Latest value = CALCULATE(LASTNONBLANK(Table[value],""),FILTER(Table,MAX(Table[Date])))
and then
=if(HASONEFILTER(Table1[Name]),LOOKUPVALUE(Table1[Value],Table1[Date],[Latest value],Table1[Name],VALUES(Table1[Name])),BLANK())
the result is showing all blank in matrix table.
Could you help me with this issue if I share my file , please?
Super UserHi,
Share some data, describe the question and show the expected result.
here is the link:
https://drive.google.com/file/d/1MfOo9ZGu0Omc3QO55B1ts3rLkUcNqDb4/view?usp=sharing
i am looking for the result something like this, and whenever i choose something from a slicer it should filter the table based on slicer order.
Type qty Smartphones 65 VIVO 4 Motorola 5 LG 7 Samsung G22 6 Lenovo 8 Apple Iphone 13 7 One Plus 10 Huawei 5 Nokia 9 Xiaomi 4 Laptop 39 Apple 5 Toshiba 9 Asus 7 HP 1 Dell 5 Samsung 4 Acer 8 Thanks in advance!
- Ashish_Mathur
I do not understand your question at all. May be someone else can help you.
Okay, sorry for taking your time but let me try one more time please. I have a dataset which looks like below and would like to find the last qty of each product based on id:
id Product qty 10001 Lenovo 1 10002 VIVO 4 10003 Huawei 5 10004 Lenovo 8 10005 VIVO 9 and i would like to see out put like this:
id Product qty 10003 Huawei 5 10004 Lenovo 8 10005 VIVO 9 i have tried function like this below but the result is in matrix table is empty cells
Latest value = CALCULATE(LASTNONBLANK(Table[qty],""),FILTER(Table,MAX(Table[id])))
and then:
=if(HASONEFILTER(Table[Product]),LOOKUPVALUE(Table[qty],Table[id],[Latest value],Table[Product],VALUES(Table[Product])),BLANK())
i would really appreciate if you could help me with this issue. Thank you!
- Ashish_Mathur
Hi,
Try these measures
Max ID = MAX(Data[id])Qty at Max ID = CALCULATE(SUM(Data[qty]),FILTER(VALUES(Data[id]),Data[id]=CALCULATE([Max ID],all(Data[id]))))Hope this helps.