Forum Discussion
Unwanted Current Week + 1 Column
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
ckhoo2007 , Change delta like , if needed last week too
Delta % =if(isblank([This week]), blank(), divide([This week] -[Last Week], [Last Week]))
2 Replies
- amitchandakSuper User
ckhoo2007 , Change delta like , if needed last week too
Delta % =if(isblank([This week]), blank(), divide([This week] -[Last Week], [Last Week]))
- ckhoo2007Helper I
Thanks Amit!