Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
We have quotes to customers updated many times a day. I'm trying to get a table that shows the latest update for each customer for each day. I managed to get a table that shows me the latest update for each day but NOT for each customer for each day. Just need to add another grouping or filter but don't know how... This is what I have for the table:
Thank ou for the reply...the issue is the customer id is in a table other than datetable and I cannot seem to find how to add another allexcept when doing two tables. I have tried
Add the customer to ALLEXCEPT
User | Count |
---|---|
140 | |
113 | |
104 | |
76 | |
63 |
User | Count |
---|---|
135 | |
126 | |
110 | |
70 | |
61 |