while calculate last week sale first week shows blank

[Anonymous]

Hi All,

While calculating Week over Week change the first-week record is blank, I trying

Sales WOW =

VAR ThisWeek = MAX(Sales[Week])

RETURN

CALCULATE(SUM(Sales[Price]),Sales[Week] = ThisWeek -1)

for 2020 first Week it needs to fetch the record of last week of 2019 and so on.

Thank You

[Anonymous]

Please do yourself a favor and follow the rules of correct dimensional modeling. You should first of all have a proper Date table in your model and secondly slice only by dimensions, never directly on your fact table's columns.

Then and only then will you be able to build correct calculations. Dealing with weeks is a tricky issue. Please follow this link:

https://www.sqlbi.com/articles/week-based-time-intelligence-in-dax/

Best
D

[az38]

@Anonymous 

do you have a column with Year?

[Anonymous]

Yes, Year column is available in my table