Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello everyone
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.
Kindly assist.
Solved! Go to Solution.
If you need a Table
Go to Modelling Tab>>>NEW TABLE and then use this formula.
New Table = SUMMARIZE ( TableName, TableName[Customer ID], "Last Date", MAX ( TableName[Date] ), "Last Product", CALCULATE ( FIRSTNONBLANK ( TableName[Product], 1 ), FILTER ( TableName, TableName[Date] = MAX ( TableName[Date] ) ) ) )
User | Count |
---|---|
101 | |
90 | |
78 | |
70 | |
69 |
User | Count |
---|---|
110 | |
96 | |
95 | |
74 | |
71 |