Unwanted Current Week + 1 Column

[ckhoo2007]

Hi All,

I have created a column using the following to show the weekly difference:

Week Rank = RANKX(all('Date'),'Date'[Year Week],,ASC,Dense) //YYYYWW format

measures
This Week = CALCULATE(sum('order'[Qty]), FILTER(ALL('Date'),'Date'[Week Rank]=max('Date'[Week Rank])))
Prev Week = CALCULATE(sum('order'[Qty]), FILTER(ALL('Date'),'Date'[Week Rank]=max('Date'[Week Rank])-1))

Delta % = divide([This week] -[Last Week], [Last Week])

So far it works fine if I display only This Week in a matrix, e.g. if this is week 25, it will show only week 25, however when I add Prev Week or Delta % in the matrix, it will show week 26 (Current Week + 1) with no This Week data and only Prev Week data , how do I get rid of that?

Thanks in advance.

Regards,

Choo

[amitchandak · Accepted solution]

@ckhoo2007 , Change delta like , if needed  last week too

Delta % =if(isblank([This week]), blank(), divide([This week] -[Last Week], [Last Week]))

[ckhoo2007]

Thanks Amit!