Forum Discussion
Solved
Find two different last date in the same column
Hello everyone. I'm facing an issue and you may help me with that. As you will see in the table below, I have four columns : invoice_number, invoice_date, customer_number, customer_machine_number. ...
I finally solve the problem with this measure :
Date1 = CALCULATE( MAX([INVOICE_DATE]), FILTER(INVOICE_TABLE, AND(CUSTOMER_NUMBER <> BLANK(), MACHINE_NUMBER <> BLANK())))And for the second date, just do Date2 = MAX(INVOICE_DATE)
I finally solve the problem with this measure :
Date1 = CALCULATE( MAX([INVOICE_DATE]), FILTER(INVOICE_TABLE, AND(CUSTOMER_NUMBER <> BLANK(), MACHINE_NUMBER <> BLANK())))
And for the second date, just do Date2 = MAX(INVOICE_DATE)