Forum Discussion

gregormc's avatar
gregormc
New Member
2 years ago

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 balance...
Need Help
amitchandak's avatar
amitchandak
Super User
2 years ago

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-5c3243d1f9

  • gregormc's avatar
    gregormc
    New Member
    2 years ago

    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