Same day and next day numbers appearing on same line in column

[Anonymous]

Hello All,

I need help in a task that I have been trying to accomplish.

So I have three columns - invoice number, outstanding amount and date

Now in a matrix I am trying to visualize something line this - 

Date    Same Date Outstanding Amount (Summed up)      Next Date Oustanding Amount(Summed up)    Delta between the 2 numbers

The idea behind such a visual to calculate the opening balance and closing balance for each date of the month

Any help would be appreciated.

[v-piga-msft]

Hi @Anonymous ,

Have you solved your problem?

If you have solved, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.

If you still need help, please share some data sample and your desired output so that we could help further on it.

Best Regards,

Cherry

[AnthonyTilley · Accepted solution]

If i have your idea correct teh you can just use next day 

for example use the follwing 3 measures

Same Date Outstanding Amount (Summed up) = sum('Table'[OutstandingAMT])

Next Date = CALCULATE(sum('Table'[OutstandingAMT]),NEXTDAY('Table'[date]))

Diff = Next Date - Same Date Outstanding Amount (Summed up)