Change in values from one day to the next in a matrix

[LFM]

Hi. How can I calculate the change of values from one day to the next in this matrix? I want a similar matrix like this, just that I replace the values of required margin with values that show change from the previous day. I also hope it can show values that skip the weekends.

[Anonymous · Accepted solution]

Hi @LFM ,

Below is my table:

The following DAX might work for you:

IsWeekday = IF(WEEKDAY('Table'[Date], 2) < 6, TRUE, FALSE)


SalesChange = 
VAR CurrentSales = SUM('Table'[2024])
VAR PreviousSales = CALCULATE(SUM('Table'[2024]), PREVIOUSDAY('Table'[Date]), 'Table'[IsWeekday] = TRUE)
RETURN CurrentSales - PreviousSales

Firstly , you can create a column named IsWeekday to examine the weekday. Secondly , you can create the SalesChange to calculate the current day's sales and subtracts the previous weekday's sales from it.

The final output is shown in the following figure:

Best Regards,

Xianda Tang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.