Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

DAX Measure Suggestion

Hi, I am trying to build a DAX Measure for Count of number of companies has been created after the first invoice    We have invoice creation date(Invoice_Create Date)column and company establish...
Anonymous's avatar
Anonymous
Not applicable
3 years ago

Company Id, Country ID, COmpany Est Date and Invoice created date are belongs to same table.

tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity Champion
3 years ago

Anonymous 
Does the Country ID refer to the company or to the invoice?

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    yes tamerj1 i need to check, if there is any invoices created with the company id on a specific country code before the company established date.

    • tamerj1's avatar
      tamerj1
      Icon for Community Champion rankCommunity Champion
      3 years ago

      Anonymous 
      Ok. Are you trying to calculate the number of invoices or the number of companies? I'm asking this because the title contradicts with your dax code attempt.

      • Anonymous's avatar
        Anonymous
        Not applicable
        3 years ago

        I need both num of invoices and number of companies info but primarily i am working on Number of companies that has been created after the first invoice out of total no of the companies that has been created