Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Im trying to get the last day I have a record of extracted from a data set. I have delivery dates that are duplicated, so the LASTDAY formula doesn't work and when I try to use the DISTINCT function before the LASTDAY function I still get an error message.
Why dont you try MAX ( Table1[Delivery Date]) ?
If this is not you expect, please share how do you want to display the result.
Thanks
Raj
When I try this solution it gives me a date that is not actually in the dataset. Last day in the set is January 18th and it gives me December 31st
Can you provide the data in text format , so that i can copy/ paste and try? Also, out of 3 columns, which column latest date you are trying to fetch?
Hi @nicolasgh96,
How did you do it? It's good and simple. Please refer to the snapshot below.
Best Regards,
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
87 | |
64 |