Forum Discussion

Frequent Visitor

7 years ago

Solved

Excel formula to Power BI

Hi, Can anyone help me to convert the below excel formula to power BI DAX? =SUMIFS([@[NET OWING]],[@DATE],">="&TODAY()-15)

Anonymous
7 years ago
=CALCULATE (
SUM ( Table1[NET OWING] ),
FILTER ( Table1, Table1[Date] >= ( TODAY () - 15 ) )
)
Anonymous
7 years ago
It'll basically be the same formula but twice, with the days changed to 59 and 29

CALCULATE (
    SUM ( Table1[NET OWING] ),
    FILTER ( Table1, Table1[Date] >= ( TODAY () - 59 ) )
)
    - CALCULATE (
        SUM ( Table1[NET OWING] ),
        FILTER ( Table1, Table1[Date] >= ( TODAY () - 29 ) )
    )

Anonymous

Not applicable

7 years ago

=CALCULATE (
SUM ( Table1[NET OWING] ),
FILTER ( Table1, Table1[Date] >= ( TODAY () - 15 ) )
)

Frequent Visitor

7 years ago

Thanks Chirayuw.

Can you help me again to covert the excel formula below?

=SUMIFS([@[NET OWING]],[@Date],">="&TODAY()-59)-SUMIFS([@[NET OWING]],[@Date],">="&TODAY()-29)

Anonymous
Not applicable
7 years ago
It'll basically be the same formula but twice, with the days changed to 59 and 29

CALCULATE (
    SUM ( Table1[NET OWING] ),
    FILTER ( Table1, Table1[Date] >= ( TODAY () - 59 ) )
)
    - CALCULATE (
        SUM ( Table1[NET OWING] ),
        FILTER ( Table1, Table1[Date] >= ( TODAY () - 29 ) )
    )