topic Re: Year Total in DAX Commands and Tips

Year Total

amandabus21 — Thu, 09 Mar 2023 17:52:58 GMT

How can I get a year total of my meausre. As in I always want the whole total of the current year.

Measure is =Accidents Per 100K Miles

Date:

'Datamart AccidentSummary'[Merged FC])

So a total of 2023 that keeps updating as the year goes on.

And a previous total of 2022.

FreemanZ — Thu, 09 Mar 2023 18:02:13 GMT

try like:

YearTotal=

CALCULATE(

[Accidents Per 100K Miles],

YEAR('Datamart AccidentSummary'[Merged FC])=YEAR(TODAY())

)

LasrYearTotal=

CALCULATE(

[Accidents Per 100K Miles],

YEAR('Datamart AccidentSummary'[Merged FC])=YEAR(TODAY())-1

)

amandabus21 — Thu, 09 Mar 2023 18:07:03 GMT

Hi ,

First measure:

this gives me total of last month. (Dec = .91)

I need whole year (1.07)

FreemanZ — Thu, 09 Mar 2023 18:26:10 GMT

aha, then try like:

YearTotal=

CALCULATE(

[Accidents Per 100K Miles],

FILTER(

ALL('Datamart AccidentSummary'),

YEAR('Datamart AccidentSummary'[Merged FC])=YEAR(TODAY()))

)

LasrYearTotal=

CALCULATE(

[Accidents Per 100K Miles],

FILTER(

ALL('Datamart AccidentSummary'),

YEAR('Datamart AccidentSummary'[Merged FC])=YEAR(TODAY())-1)

)

amandabus21 — Thu, 09 Mar 2023 18:26:24 GMT

nevermind had the wrong filters!