topic Re: while calculate last week sale first week shows blank in DAX Commands and Tips

while calculate last week sale first week shows blank

Anonymous — Fri, 06 Mar 2020 09:28:30 GMT

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

Re: while calculate last week sale first week shows blank

az38 — Fri, 06 Mar 2020 09:48:20 GMT

Anonymous

do you have a column with Year?

Re: while calculate last week sale first week shows blank

Anonymous — Fri, 06 Mar 2020 09:52:00 GMT

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

Re: while calculate last week sale first week shows blank

Anonymous — Fri, 06 Mar 2020 10:18:44 GMT

Yes, Year column is available in my table