Latest Order by Customer using MAXX not working

[Varun511]

HI team,

want to find out Max date or when he placed the latest order 

I am trying formula like below

Want to add Date Column but i am not able to see Date table want o understand the reason why i cant see date table 

Can any one help me how to achieve the solution to find the latest order by customer

[v-xiaotang]

Hi @Varun511 

Have you solved this problem? If yes, to help others find answer faster, could you kindly accept the answer helpful as the solution? Or could you kindly share your solution to improve Power BI?
Really appreciate!
Any question, please let me know. Looking forward to receiving your reply.

Best Regards,
Community Support Team _Tang

[v-xiaotang]

Hi @Varun511 

do you mean you want to calculate the max date in table Customer? If so, you can try Calculate(max(Customer[date]),All(Customer)). If there is no [date] column in table Customer, you need a column to associate Customer with Date, then calculate the max date.

by the way, the syntax of Maxx is like this,

https://docs.microsoft.com/en-us/dax/maxx-function-dax

Best Regards,

Community Support Team _Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

[Greg_Deckler]

@Varun511 Sorry, having trouble following, can you post sample data as text and expected output?
Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882

Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.

[Varun511]

HI Greg,

Not able to Upload  any attachments can you please guide me  ?

Thanks,

Varun

[Greg_Deckler]

@Varun511 Post sample data as text or upload a PBIX to OneDrive or Box or something and share the link.