Forum Discussion

Kashinoda's avatar
Kashinoda
Advocate I
8 years ago

Using DAX operators on multiple Dates from the same Fact table?

Hi Guys,   This has been doing my head in a little.   I have a Date Dimension Table and a Fact Table with multiple Date Columns.   I wish to find an arbitary total, on the condition that DATE1 ...
v-huizhn-msft's avatar
v-huizhn-msft
Microsoft Employee
8 years ago

Hi Kashinoda,

Please confirm your [FKCreditDate] and [FKInvoiceDate] are date type, then try the following formula and check if it works fine.

Paid Invoices within 90 Days =
CALCULATE (
    [Collections Total],
    FILTER (
        FactCredits,
        FactCredits[FKCreditDate]
            <= DATE ( YEAR ( FactCredits[FKInvoiceDate] ), MONTH ( FactCredits[FKInvoiceDate] ), DAY ( FactCredits[FKInvoiceDate] ) + 90 )
    )
)


Best Regards,
Angelia