Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
needs to be in the same grid so it can be extracted
want customer to be able to see filtered donations and their last donation (unfiltered)
Solved! Go to Solution.
@Anonymous
You may add a calculated table.
Table = GENERATE ( Table1, SELECTCOLUMNS ( TOPN ( 1, FILTER ( Table1, Table1[customer] = EARLIER ( Table1[customer] ) ), Table1[gift_date], DESC ), "gift_date_last", Table1[gift_date], "gift_amount_last", Table1[gift_amount] ) )
@Anonymous
You may add a calculated table.
Table = GENERATE ( Table1, SELECTCOLUMNS ( TOPN ( 1, FILTER ( Table1, Table1[customer] = EARLIER ( Table1[customer] ) ), Table1[gift_date], DESC ), "gift_date_last", Table1[gift_date], "gift_amount_last", Table1[gift_amount] ) )
Sorry but this ran me out of memory. It is a good solution for smaller data sets.
User | Count |
---|---|
141 | |
113 | |
104 | |
78 | |
64 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |