Week to Date Last Year no working as expected

SID77 — Thu, 07 Sep 2023 13:34:46 GMT

Hi everyone,

This is my first post looking for help so please be kind.

I am trying to make my Week to Date Last year **bleep** up through the days of the week,

So WTD Monday sales = Monday sales

WTD Tuesday sales = Monday + Tuesday sales and so on throughout the week,

I have manged to make this year (CAL WTD) dax work (highlighted green) but last year (CAL WTD LY - highlighted red) is just giving me a total for the week against each day - as per screenshot below.

My cuurent dax calcs are as below:

CAL WTD =

IF (

HASONEVALUE ( MH_Calendar[Year] )

&& HASONEVALUE(MH_Calendar[Week of Year]),

CALCULATE (

[Net Sales Value],

FILTER (

ALL( MH_Calendar ),

MH_Calendar[Year] = VALUES ( MH_Calendar[Year] )

&& MH_Calendar[Week of Year] = VALUES ( MH_Calendar[Week of Year])

&& MH_Calendar[Date] <= MAX ( MH_Calendar[Date])

)

BLANK ()

)

CAL WTD LY =

IF (

HASONEVALUE ( MH_Calendar[Year] )

&& HASONEVALUE(MH_Calendar[Week of Year]),

CALCULATE (

[Net Sales Value],

FILTER (

ALL( MH_Calendar ),

MH_Calendar[Year] = VALUES ( MH_Calendar[Year] ) -1

&& MH_Calendar[Week of Year] = VALUES ( MH_Calendar[Week of Year])

&& MH_Calendar[Date] <= MAX ( MH_Calendar[Date])

)

BLANK ()

)

As you can see I have moved the year out buy adding the -1 to the calc, but I am now stuck - weirdly I am using the same logic for a 445 calendar and it works beautifully.

I love power bi but time intelligence is my nemesis - I can be stuck for days on a seemly simple calc 🤔

I appriciate all of your help and feedback.

Thanks

Re: Week to Date Last Year no working as expected

lbendlin — Sun, 10 Sep 2023 01:52:14 GMT

Yeah, there is not much time intelligence left once you go to week level.

Please provide sample data (with sensitive information removed) that covers your issue or question completely, in a usable format (not as a screenshot). Leave out anything not related to the issue.
https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Please show the expected outcome based on the sample data you provided.

https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

topic Re: Week to Date Last Year no working as expected in DAX Commands and Tips

Week to Date Last Year no working as expected

Re: Week to Date Last Year no working as expected