I have a table where I have captued the customer ID and the list of products they purchased and when (date/time).
From this I want to know which was the last product they purchased.
But I cannot seem to figure out the method to extract this result.
Here is what my data looks like and the expected result.
Go to Solution.
FIRSTNONBLANK ( TableName[Product], 1 ),
FILTER ( TableName, TableName[Date] = MAX ( TableName[Date] ) )
thanks bhai for the help! works superb.
Check out the on demand sessions that are available now!
Check out the Winners!
Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.