topic help me with the dax in DAX Commands and Tips

help me with the dax

iyanaardnas1 — Tue, 14 May 2024 19:00:18 GMT

Hi All,
I Want to fetch the Values for all the months in the slicer from the below dax1.
i have 2 dax's where dax1 is fetching correct values(totals) but month slicer for prev month selection displaying blank and other dax2 not correct value (totals) but fetching for all months with month slicer. so can anyone help me in modifying DAX1 (HC new).

dax used are:
Dax1(prev month and year not fetching values but value is correct)

HC new =

VAR MaxActivityDate = MAX(sales_snap[Activitydate])

RETURN

IF(

TODAY() = MaxActivityDate,

CALCULATE(

SUM(sales_snap[HeadCount]),

FILTER(

sales_snap,

sales_snap[Activitydate] = MaxActivityDate

)

)
DAX2(prev month and year fetching values but value is incorrect)

HeadCount = CALCULATE(SUM(sales_snap[HeadCount]),LASTDATE(sales_snap[Activitydate]))

Re: help me with the dax

iyanaardnas1 — Tue, 14 May 2024 18:07:45 GMT

any answers?

Re: help me with the dax

Anonymous — Wed, 15 May 2024 01:33:48 GMT

HI iyanaardnas1,

You can try to use the following measure formulas if it suitable for your requirement:

HC new = VAR MaxActivityDate = MAX ( sales_snap[Activitydate] ) RETURN IF ( TODAY () = MaxActivityDate, CALCULATE ( SUM ( sales_snap[HeadCount] ), FILTER ( ALLSELECTED ( sales_snap ), sales_snap[Activitydate] = MaxActivityDate ) ) )

Regards,

Xiaoxin Sheng