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)
mh2587's avatar
mh2587
Icon for Super User rankSuper User
4 years ago

measure 1 =  // where machine and customer number not null

CALCULATE(MIN(Table[Invoice Date]),AND('Table'[Customer_Number] <> BLANK(),'Table'[Machine_Number] <> BLANK())
measure 2 = MIN(Table[Invoice Date])
  • eric98's avatar
    eric98
    Icon for Helper II rankHelper II
    4 years ago

    Hello !

    Thank for your help, but this measures doesn't work...

    I found the good date for the measure 2 but not for the measure 1

    • mh2587's avatar
      mh2587
      Icon for Super User rankSuper User
      4 years ago

      try max in place MIN hope this will give you the output 

      • eric98's avatar
        eric98
        Icon for Helper II rankHelper II
        4 years ago

        I've already try that with MAX!