Comparison vs same week last year

bo_afk 

You need to set up a Calendar table (either in Power Query or using DAX functions CALENDAR() or CALENDARAUTO()), link the date fields in a one-to-many relationship from the Calendar table to your data table and then use the Calendar date field for your time intelligence calculations (and for measures, slicers and filters for that matter).

For time intelligence functions to work, you require a set of continuous dates (unique) which obviously must cover the whole range of dates in your data.

See if my Time Intelligence the Hard Way provides a different way of accomplishing what you are going for.

https://community.powerbi.com/t5/Quick-Measures-Gallery/Time-Intelligence-quot-The-Hard-Way-quot-TITHW/m-p/434008

Create a date calendar as given in the links and following functions can help

YTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESYTD(('Date'[Date]),"12/31"))
Last YTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESYTD(dateadd('Date'[Date],-1,Year),"12/31"))
Last YTD complete Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESYTD(ENDOFYEAR(dateadd('Date'[Date],-1,Year)),"12/31"))
Last to last YTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESYTD(dateadd('Date'[Date],-2,Year),"12/31"))
Year behind Sales = CALCULATE(SUM(Sales[Sales Amount]),dateadd('Date'[Date],-1,Year))
2 Year behind Sales = CALCULATE(SUM(Sales[Sales Amount]),dateadd('Date'[Date],-2,Year))

To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s.

Refer
https://radacad.com/creating-calendar-table-in-power-bi-using-dax-functions
https://www.archerpoint.com/blog/Posts/creating-date-table-power-bi

https://www.sqlbi.com/articles/creating-a-simple-date-table-in-dax/

Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blog -
Winner-Topper-on-Map-How-to-Color-States-on-a-Map-with-Winners , HR-Analytics-Active-Employee-Hire-and-Termination-trend
Power-BI-Working-with-Non-Standard-Time-Periods And Comparing-Data-Across-Date-Ranges

Connect on Linkedin

Hi, bo_afk 

Based your description, I created data to reproduce your scenario.

DateTable(a calculated table):

DateTable = 
CALENDAR(DATE(2019,1,1),DATE(2020,12,12))

Sales:

There is a one-to-one relationship between two tables.

Then you may create measures as follows.

Sales this year-week = 
var _date = MAX(Sales[Date])
var _year = YEAR(_date)
var _week = WEEKNUM(_date)
return
IF(
    ISBLANK(MAX(Sales[Date])),
    BLANK(),
    CALCULATE(
        SUM(Sales[Sales]),
        FILTER(
            ALLSELECTED(Sales),
            YEAR(Sales[Date]) = _year&&
            WEEKNUM(Sales[Date]) = _week
        )
    )
)

Sales last year-week = 
var _date = MAX(Sales[Date])
var _lastyear = YEAR(_date)-1
var _lastweek = WEEKNUM(_date)

return

    CALCULATE(
        SUM(Sales[Sales]),
        FILTER(
            ALL(Sales),
            YEAR(Sales[Date]) = _lastyear&&
            WEEKNUM(Sales[Date]) = _lastweek
        )
    )

Year-Week change = 
if(
    ISBLANK(Sales[Sales last year-week]),
    BLANK(),
    Sales[Sales this year-week] - Sales[Sales last year-week]
)

Result:

Best Regards

Allan

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