topic Re: DAX Measures WTD with DayNumber in DAX Commands and Tips

DAX Measures WTD with DayNumber

DGTL — Fri, 03 Nov 2023 10:46:17 GMT

Good morning,

I am asking you about a DAX measurement.

Indeed, I would like to compare the Y-1 value for the same NumDayWeek from the previous year.

In order to make a WTD

I have a date table

Can you help me ?

Re: DAX Measures WTD with DayNumber

Jihwan_Kim — Sat, 04 Nov 2023 03:54:01 GMT

Hi,

I am not sure if I understood your question correctly, but please check the below picture and the attached pbix file.

Value Y: = SUM( Data[Value] )

Value Y-1: = VAR _lastyear = MAX ( Data[Year] ) - 1 VAR _samenumdayweek = MAX ( Data[NumDayWeek] ) RETURN CALCULATE ( SUM ( Data[Value] ), Data[Year] = _lastyear && Data[NumDayWeek] = _samenumdayweek )

Re: DAX Measures WTD with DayNumber

DGTL — Mon, 06 Nov 2023 15:53:12 GMT

Good morning,

Thank you for your reply,

But I would have to compare day 5 of week 2 of the year 2022

with day 5 of week 2, of the year 2023

Day 5 is not necessarily the same day. It's the fifth day of week 2.

You see ?

thanks again 🙂

Re: DAX Measures WTD with DayNumber

v-zhangti — Wed, 08 Nov 2023 09:31:51 GMT

Hi, DGTL

You can try the following methods.

Measure:

Value Y = CALCULATE(MAX('Table'[Value]),FILTER(ALL('Table'),[Week]=SELECTEDVALUE('Table'[Week])&&[NumDayWeek]=SELECTEDVALUE('Table'[NumDayWeek])&&[Year]=YEAR(TODAY())))

Value Y-1 = CALCULATE(MAX('Table'[Value]),FILTER(ALL('Table'),[Week]=SELECTEDVALUE('Table'[Week])&&[NumDayWeek]=SELECTEDVALUE('Table'[NumDayWeek])&&[Year]=YEAR(TODAY())-1))

Is this the result you expect?

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.