Calculating values at specific levels/points in the report?

[Topographical]

I have data that I've laid out by date, then by unique number, and at those points of the report, I need to perform a certain calculation based on items associated with that unique number.

I'd then need to aggregate values at those specific points of the report.

What would be the best way of going about this?

I created a sample file to show what I mean, but can't seem to upload the file.

So I basically want to calculate at this point, for every one of these points:

That is the view, drilled down through the dates and into the uniques

[MFelix]

Hi @Topographical,

What type of calculation you wan to do based on your explanation this is can be achieve with a measure in DAX however without further explanations I'm unable to help better.

Can you provide a sample of your data, explanation of calcutation to be made and expected result.

thank you

Regards,

Mfelix

[Topographical]

Hi there,

Here is the sample data I prepared that feeds into the screenshot I used above.

So basically the calculation that I need at the point that I showed above would be based on the "items", so let's say for this simple example that the calculation would need to be the sum of x - the sum of y, for each unique, for each month, basically. 

Thank you!

[Topographical]

Hi there,

I am expecting x -y for each unique for each month (ie not row by row, but just for those points), and then I'd like to aggregate those values. 

[Ashish_Mathur · Accepted solution]

Hi,

Try this calculated column formula

=CALCULATE(SUM([Amounts]),FILTER(Data,[Date]=EARLIER([Date])),Data[Items]="x")-CALCULATE(SUM([Amounts]),FILTER(Data,[Date]=EARLIER([Date])),Data[Items]="y")

Hope this helps.

[Topographical]

Thank you for this! I will give it a try.

[Ashish_Mathur]

Hi,

What result are you expecting in column E.  Please show those numbers.