Forum Discussion
Latest Value
Hi Guys, I need some help on this. Here's my data: Date Store Product Answer 16/07/2018 McDonald Pizza Yes 17/07/2018 McDonald Pizza No 16/07/2018 McDonald Burger No 1...
Anonymous
As a NEW Table ("Calculated Table"), you can use
New Table = VAR temp = ADDCOLUMNS ( Table1, "RANK", RANKX ( FILTER ( Table1, [Store] = EARLIER ( [Store] ) ), [Date],, DESC, DENSE ) ) RETURN FILTER ( temp, [RANK] = 1 )
Ashish_Mathur
Super User
Super UserHi Ashish,
Thanks for your help.
However, I need a measure that will display the value for Answer in any visualisation. Is that possible?
And/or create a new table in DAX that filters the below data only:
Date Store Product Answer 17/07/2018 McDonald Pizza No 17/07/2018 McDonald Burger No 17/07/2018 KFC Pizza Yes 17/07/2018 KFC Burger Yes Thanks
- Ashish_Mathur
Hi,
That is what my solution does. Perhaps i do not understand your requirement.
Hi Ashish,
Can you please let me know the syntax for producing the below new table in DAX?
Using this feature:
Date Store Product Answer 17/07/2018 McDonald Pizza No 17/07/2018 McDonald Burger No 17/07/2018 KFC Pizza Yes 17/07/2018 KFC Burger Yes Thank you