Previous year Week to date

[stino123]

Hey,

I am trying to create a week to date measure for previous year same day. Generally speaking my function (See below) works. But I do get blanks on random days. Would someone know why?

Function:

Net sales PWTD =

var __currentYear = SELECTEDVALUE( 'Calendar'[Year-Month Sort] )

    var __currentWeek = SELECTEDVALUE( 'Calendar'[ISO Week])

    var __lastDayNumberInWeek = MAX( 'Calendar'[Day of Week] )

    var __lastYear = __currentYear - 1

    var __prevWeek = __currentWeek

    var __output =

        CALCULATE(

           [Nett Sales],

            'Calendar'[Year-Month Sort] = __lastYear,

            'Calendar'[ISO Week] = __prevWeek,

            'Calendar'[Day of Week] <= __lastDayNumberInWeek,

            ALL( 'Calendar')

        )

    return

        __output

Result:

[stino123]

Hey @amitchandak the first blog post helped find my solution, thanks for this! Would you know why my dax resulted in blanks?

[amitchandak · Accepted solution]

@stino123 , refer my blog on same topic

Power BI — Week on Week and WTD
https://medium.com/@amitchandak.1978/power-bi-wtd-questions-time-intelligence-4-5-98c30fab69d3
https://community.powerbi.com/t5/Community-Blog/Week-Is-Not-So-Weak-WTD-Last-WTD-and-This-Week-vs-La...
https://www.youtube.com/watch?v=pnAesWxYgJ8

For week start date

Any Weekday Week - Start From Any day of Week
https://community.powerbi.com/t5/Community-Blog/Any-Weekday-Week-Decoding-Date-and-Calendar-2-5-Powe...
https://medium.com/chandakamit/cheat-sheet-any-weekdays-week-start-date-just-one-variable-apart-6b2e...