Forum Discussion
Visualise the increase/decrease of a value based on non consecutive dates
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
2 Replies
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-5c3243d1f9Thank 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
