how can i get the last invoices date for each custmer by reports or by Powe BI iam using BC?

[ahmed-]

how can i get the last invoices date for each custmer by reports or by Powe BI iam using BC?

[v-hjannapu]

Hi @ahmed-,

Thank you  for reaching out to the Microsoft fabric community forum.
Thank you @Ashish_Mathur, @ray_aramburo for your response regarding issue.

By using this Dax you get the last invoices date for each customer.

Last_Invoice_Date = 
CALCULATE(
    MAX(InvoicesDataTable[InvoiceDate]),
    ALLEXCEPT(InvoicesDataTable, InvoicesDataTable[CustomerID])
)

 I tested it with my sample data, and it worked fine. Please find the attached Pbix for your reference.
If this solution worked for you, kindly mark it as Accept as Solution and feel free to give a Kudos, so others can benefit as well.

Best Regards,
Harshitha.

[Ashish_Mathur]

Hi,

What is BC?  Using measures, you will have to use the LASTNONBLANK() function.  To receive more help, share some data to work with and show the expected result.  Share data in a format that can be pasted in an MS Excel file.

[ray_aramburo]

Hi @ahmed-  you will need to create a measure with a similar structure like this (I don't knpw your data) : 

Last_Invoice_Date = CALCULATE(MAX(InvoicesDataTable[InvoiceDate]), ALLSELECTED(CustomersDataTable[Customer]))

If this is helpful mark it as solved so it can help for future references, otherwise, kindly provide more details of your data.