Forum Discussion

eric98's avatar
eric98
Icon for Helper II rankHelper II
4 years ago
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. ...
Need Help
  • eric98's avatar
    eric98
    4 years ago

    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)
eric98's avatar
eric98
Icon for Helper II rankHelper II
4 years ago

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)