Sum value by date

[Anonymous]

Any1 know what's wrong with below DAX?

2017Exp = calculate(sum(XeroMasterExport[ActualExp]),XeroMasterExport[Date]=2017)

[Sean · Accepted solution]

Yes you need to use the YEAR function

2017Exp =
CALCULATE (
    SUM ( XeroMasterExport[ActualExp] ),
    YEAR ( XeroMasterExport[Date] ) = 2017
)

HTH!

EDIT: Well you may need to use this instead if you are using any slicers that cause the above to give you blank

2017Exp =
CALCULATE (
    SUM ( XeroMasterExport[ActualExp] ),
    FILTER ( ALL ( XeroMasterExport ), YEAR ( XeroMasterExport[Date] ) = 2017 )
)

[Anonymous]

@Seanworked, easy, i love this place!!  thanks!