Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi everyone
I'm trying to find the latest date per customer using DAX but I'm hitting a problem. The example below shows the fields ContactID, Position, DateAdded, LatestDate
I'm using the following DAX fomula, and in this case I'd expect the final column to show 07/02/2023 (i.e. the latest DateAdded for the particular ContactID).
I don't think we're getting the full information here. e.g. why is there a LatestDate and a Max_Date?
Can you put a small sample pbix together and post a link here please?
User | Count |
---|---|
98 | |
87 | |
77 | |
67 | |
63 |
User | Count |
---|---|
110 | |
95 | |
95 | |
64 | |
58 |