Last Week Values are not populating properly

[vijayvizzu]

Hi

I have created below measure to get the Last week value, but it skips some of the rows, unable to find out the reason.

X_Test_Measure = 

VAR _LW_Price = 
    CALCULATE(
        [Total Value],
        DATEADD(
            CalendarT[Date],
            -7,DAY
        )
    )
RETURN 
IF(ISBLANK([Total Value]),BLANK(),_LW_Price)

[Anonymous · Accepted solution]

Hi @vijayvizzu ,

You are using '-7' in your formula, and there's no matched date so it returns blank.

You may consider to modify the last part of your formula as below.

IF(ISBLANK(_LW_Price),BLANK(),[Total Value])

It will return the total value if last week price is blank.

Best Regards,

Jay