Day to Day difference with 2 variables

[driesvdb]

Hello,

I made a db where our printerdata is sent to on a daily basis. 6 properties/OID's are scanned:

• copy count black
• copy count color
• total copy
• print count black
• print count color
• total print

I want to add an extra column wich calculates the difference from the last day but for the same printer and OID.

So far i got something like this:

Count(Daily) =

VAR PrintPreviousDay =

CALCULATE (

SUM ( COUNTER[Count] );

FILTER (

ALL ( COUNTER );

COUNTER[Date]

= EARLIER ( COUNTER[Date] )-1

&& COUNTER[PrinterID] = EARLIER ( COUNTER[PrinterID] )

&& COUNTER[TypecounterID] = EARLIER( COUNTER[TypecounterID] )

)

)

RETURN

COUNTER[Count] - PrintPreviousDay

But the new column only copies the count value instead of substracting it from the previous day.

PrinterID   TypecounterID    Date         Count      Count(Daily)

Any help is appreciated to fix my formula.

Thanks

Dries

[v-frfei-msft · Accepted solution]

Hi @driesvdb ,

To create a measure as below.

difference = 
VAR dat = [Date] - 1
VAR pre =
    CALCULATE (
        SUM ( 'Table'[Count] ),
        FILTER (
            'Table',
            'Table'[PrinterID] = EARLIER ( 'Table'[PrinterID] )
                && 'Table'[TypecounterID] = EARLIER ( 'Table'[TypecounterID] )
                && [Date] = dat
        )
    )
RETURN
    IF ( pre = BLANK (), BLANK (), 'Table'[Count] - pre )

[driesvdb]

Hi @v-frfei-msft 

When I enter the lines the collumn is still empty, no calculation seems te be done.

In the link below is the .pbix file ( I don't have enough rights to upload it directly )

https://vgdeu-my.sharepoint.com/:u:/g/personal/dries_van_den_bossche_vgd_eu/ETYtyNXf-yJNrMl001ASATYB...