Last Week Total in If(IsBlank)

Hi BrettM ,

According to the formula you provided, it should be calculating the total number of boxes shipped in the view ('vw_PBI_ShipmentsReturns') with a specific status of 'Ship'.

Last week's total shipments are referenced in the following formula:

TotalBoxesShippedWeekPrior = 
CALCULATE(
    [TotalBoxesShipped],
    DATEADD('Date'[Date], -7, DAY) 
)

The week to week increase or decrease is referenced in the formula below:

UpDownWeekOverWeek = 
VAR CurrentWeek = [TotalBoxesShipped]
VAR WeekPrior = [TotalBoxesShippedWeekPrior]
RETURN
    IF (
        ISBLANK ( CurrentWeek ) || ISBLANK ( WeekPrior ),
        BLANK (),
        IF ( CurrentWeek > WeekPrior, "Up", "Down" )
    )

Best Regards,
Adamk Kong

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly