Visualise the increase/decrease of a value based on non consecutive dates

[gregormc]

I am looking for some assistance.  I have been tasked with adding whether the balance has increased or decreased from the previous period per column i.e. as of the 29/10/23 has the sum of the balances 'less than £250' increased or decreased in relation to period 15/10/23 and so on.  Any assistance would be greatly appreciated as I am struggling.  Thanks 

[amitchandak]

@gregormc ,

One way is have table with distinct such date and join back and create rank in that table

date rank = rankx(Dates, Dates[Date],,asc,dense)

This Date= CALCULATE(sum('Table'[Qty]), FILTER(ALL('Dates'),'Dates'[Date Rank]=max('Dates'[Date Rank])))
Last Date= CALCULATE(sum('Table'[Qty]), FILTER(ALL('Dates'),'Dates'[Date Rank]=max('Dates'[Date Rank])-1))

with a date table having all dates you can use a measure like

Last Sales = CALCULATE(lastnonblankvalues('Date'[Date],  SUM(Sales[Sales Amount])) ,filter(all('Date'),'Date'[date] <max('Date'[date])))

Day Intelligence - Last day, last non continous day
https://medium.com/@amitchandak.1978/power-bi-day-intelligence-questions-time-intelligence-5-5-5c324...

[gregormc]

Thank you for your update.

I have managed to obtain the current and previous period figures against each period.  I've run in to a further issue when trying to categorise the summed balance by the arrears band (shown below) as it's pulling the full figure in to each column.  Any ideas? TIA