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...
tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity Champion
3 years ago

Hi Anonymous 
Please try

Num of invoices created before company established =
SUMX (
    SUMMARIZE ( 'Table', 'Table'[Company ID], 'Table'[Country Code] ),
    COUNTROWS (
        FILTER (
            CALCULATETABLE ( 'Table' ),
            'Table'[Company_Create_Date] > 'Table'[Invoice_Create_date]
        )
    )
)
Num of companies created after invoice creation =
SUMX (
    SUMMARIZE ( 'Table', 'Table'[Company ID], 'Table'[Country Code] ),
    IF (
        NOT ISEMPTY (
            FILTER (
                CALCULATETABLE ( 'Table' ),
                'Table'[Company_Create_Date] > 'Table'[Invoice_Create_date]
            )
        ),
        1
    )
)
Anonymous's avatar
Anonymous
Not applicable
3 years ago

Thank you tamerj1 , i will check these two measures