Total = Balance Last Month

[Luciano]

Hi guys,

Is it possible that only the SALDODESP column total is the result of the last month instead of the sum?

All other columns are correct with the summation, however, specifically the SALDODESP column should be the result of the last month.

[kcantor · Accepted solution]

@Luciano

I do not think I understand the question. However, if that is a measure and you just need last months total you can do that using DATEADD as long as you have a date table.

Last Month SALDODESP=CALCULATE([SALDODESP], DATEADD(Date[DateKey], -1, month)) should work.

If that isn't a measure, you may need to be more specific and provide some calculations and sample data.