Forum Discussion

Hayleysea's avatar
Hayleysea
Icon for Resolver II rankResolver II
6 years ago

Last available week measure not returning correct value

I have data which is usually updated weekly but sometimes it would skip a few weeks.

 

I need a measure that I can use the compare a percentage measure from the current week to the last available week (not necessarily -7 days). 

 

I have a measure that works to give me just the date output which is: 

Last week date: CALCULATE(MAX(Table[Date]), FILTER(ALL(Table[Date]), Table[Date]<MAX(Table[Date]))
 
I also have a measure which works to give me the current week's % which is:
% Measure = IF(ISBLANK(COUNTX(FILTER(Table, Table[Latest Week Cond Form]=2), Table[code])/ COUNTX(FILTER(Table, Table[Count]="Yes"), Table[code])), "-", COUNTX(FILTER(table, table[latest Week Cond Form]=2), table[code])/ COUNTX(FILTER(Table, Table[Count]="Yes"), Table[code]))
 
I now need a measure that will give me last week's %. What I have so far is:
CALCULATE(([% Measure]), FILTER(ALL(Table[Date]), Table[Date]<MAX(Table[Date])))
 
It's giving me a percentage but not the right one. All the correct filters have been applied so I have no idea why it's not working. 
Need Help