Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
Can anyone help me to convert the below excel formula to power BI DAX?
=SUMIFS([@[NET OWING]],[@DATE],">="&TODAY()-15)
Solved! Go to Solution.
=CALCULATE (
SUM ( Table1[NET OWING] ),
FILTER ( Table1, Table1[Date] >= ( TODAY () - 15 ) )
)
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 ) )
)
=CALCULATE (
SUM ( Table1[NET OWING] ),
FILTER ( Table1, Table1[Date] >= ( TODAY () - 15 ) )
)
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)
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 ) )
)