HI ,
want to Find out the Latest Order date for each customer i tried used MAXX Function but its not working as expected Attached PBIX File
Expected output will be Customer name and his Latest order date (when he orderd recently) any help would be highly appreciated
Hello @varun,
Thank You for posting your query onto the Forum.
Well, we’re not sure what results you’re expecting here because the measure that you’ve written in your PBIX file is returning the latest date i.e. max order date as a result against particular Customer Name. The only thing was, your Sales fact table has the data till the year 2022 and the date table was loaded only till the year 2020 and therefore that could be the reason you were not getting the max date results against the particular customer name apart from that I don’t see any problem with the measure or with the results.
Here’s the screenshot of the final results once date table was extended till the year 2022.
Hoping you find this useful and helpful. 
Do let me know in case of any further queries or I missed out on something.
Thanks and Warm Regards,
Harsh
Hi @Varun , did the response provided by @Harsh help you solve your query?
If not, how far did you get and what kind of help you need further?
If yes, kindly mark as solution the answer that solved your query.
Hi @Varun, we’ve noticed that no response has been received from you since September 17.
We just want to check if you still need further help with this post? In case there won’t be any activity on it in the next few days, we’ll be tagging this post as Solved.
