Table Visual goes blank when adding measure

[GunnerJ]

I'm trying to calculate the difference between one date and the day that came before it. So for January 2nd I'd expect to see '3' (898-895=3). However when I add any combination of custom columns or measures the table goes blank.

I've tried this measure.

Daily Usage = CALCULATE(SUM('2021 Daily Usage'[BI_RDG]), PREVIOUSDAY('2021 Daily Usage'[BI_INTERVAL_RDG_DT_TM]))

And this custom Column.

TEST = CALCULATE(SUM('2021 Daily Usage'[BI_RDG]), PREVIOUSDAY('2021 Daily Usage'[BI_INTERVAL_RDG_DT_TM]),'2021 Daily Usage'[BI_ACCT] = EARLIER('2021 Daily Usage'[BI_ACCT]))

The results always return to this.

Any help in explaining what I'm overlooking would be greatly appreciated. 

Thanks

[DataInsights · Accepted solution]

@GunnerJ,

Try this calculated column:

Daily Usage Column = 
VAR vCurrentAmount = '2021 Daily Usage'[BI_RDG]
VAR vCurrentDate = '2021 Daily Usage'[BI_INTERVAL_RDG_DT_TM]
VAR vPreviousDate =
    CALCULATE (
        MAX ( '2021 Daily Usage'[BI_INTERVAL_RDG_DT_TM] ),
        ALLEXCEPT ( '2021 Daily Usage', '2021 Daily Usage'[BI_ACCT] ),
        '2021 Daily Usage'[BI_INTERVAL_RDG_DT_TM] < vCurrentDate
    )
VAR vPreviousAmount =
    CALCULATE (
        SUM ( '2021 Daily Usage'[BI_RDG] ),
        ALLEXCEPT ( '2021 Daily Usage', '2021 Daily Usage'[BI_ACCT] ),
        '2021 Daily Usage'[BI_INTERVAL_RDG_DT_TM] = vPreviousDate
    )
VAR vResult = vCurrentAmount - vPreviousAmount
RETURN
    vResult

I created additional rows to verify the logic: