Calculating week differences

[Anonymous]

Hi, 

I have created a measure to calculate this week compared to last week. But when this or last week is blank its calcuting 0 versus this or last weeks number. How can I get around this? I have tried using a IF(HASONE VALUE statement the below measure but returns "Blank" unconditionally

IF(HASONEVALUE('Dato_Kørsel'[Date]);

AVERAGE([Responstid_kørsel (min.)]) - CALCULATE(AVERAGE([Responstid_kørsel (min.)]);

FILTER(ALL(Dato);Dato[Ugenr.] = WEEKNUM(TODAY();2) -1 &&

Dato[År] = SELECTEDVALUE(Dato[År])));BLANK())

Thanks,

Mikkel

[RobbeVL]

Hi there,

Just to have an idea what your expected result is.

Are you creating a KPI card? a table ? 

[Anonymous]

Hi Robbie 

Sure, forgot that. Its a KPI card which now shows 7.7 as it is calculating difference between week 47 (7.7) and 46 (which doesnt have data). I want it to show BLANK if the week before (46) or the current week (47) is without value. 

[RobbeVL · Accepted solution]

Hi,

Hope this helps:
Might have done an overkill on variables though 🙂

Difference Last week = 
VAR
CrntWeek = WEEKNUM(TODAY())
VAR
CRNTVAL = CALCULATE(SUM('Table'[Value]); 'Table'[Week] = CrntWeek)
VAR
PrevVAL = CALCULATE(SUM('Table'[Value]); 'Table'[Week] = CrntWeek-1)
VAR
WeekDIFF = CRNTVAL - PrevVAL
RETURN

IF(CRNTVAL = BLANK() || PrevVAL = BLANK() ; BLANK() ; WeekDIFF)

[Anonymous]

Thanks Robbie! 

It works perfectly!