Forum Discussion

vijayvizzu's avatar
vijayvizzu
Helper III
5 years ago
Solved

Last Week Values are not populating properly

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)

Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    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

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    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