Delta / Difference with daily target vs multiple entries per day

[Anonymous]

Hi Everyone,

Really thankful for any guidance here. My problem is as below, I have a daily target to hit, and there are multiple entries each day, so my tables are currently giving the incorrect daily, monthly delta. I am getting the value on the left, where the daily delta is being added each entry. I want to sum all of the solds essentially but only sum the unique delta value e.g. once per day. Any ideas? 

It doesn't need to be shown as above in the table, I just need the dashboard to return the correct difference/delta, rather than adding the targets each day so that the goal is much higher and the gap much larger.

Thanks a lot,

George

[v-yanjiang-msft · Accepted solution]

Hi @Anonymous ,

According to your description, here's my solution.

1.In Power Query, add an index column.

2.Create a calculated column.

Delta =
IF (
    'Table'[Index]
        = MAXX (
            FILTER ( ALL ( 'Table' ), 'Table'[Date] = EARLIER ( 'Table'[Date] ) ),
            'Table'[Index]
        ),
    SUMX (
        FILTER ( ALL ( 'Table' ), 'Table'[Date] = EARLIER ( 'Table'[Date] ) ),
        'Table'[Sold]
    ) - 'Table'[Daily Target],
    BLANK ()
)

Get the expected result.

I attach my sample below for reference.

Best Regards,
Community Support Team _ kalyj

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