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...
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
3 years ago

Anonymous ,

 

Assume they are from same table. try this measure

 

Countx(filter(Summarize(Table, Table[Company], "_1", Min(Table[Invoice_Creation Date]), "_2", Min(Table[Company_Create_Date]) ), [_2] >[_1]), [Company])

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi Amit,
Thank You for the response,
But How the company ID is relates to Country Code?

 

  • 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.