How to create a new column/measure for daily difference from the previous day?

[jovendeluna21]

Hello,

Anyone can help on how to have a new column/measure that will show the difference from the previous day of "7 Day Rolling Average of Total Distribution per 100k". The challenge is, this column is a measure.

For example January 13 minus January 12 (8,550.20 - 8,035.99 = 514.21), January 14 minus January 13 (8,754.71 - 8,550.20 = 204.51) and so on..

Hopefully you can help me.

Herewith you can check my pbi file. Thanks!

https://drive.google.com/file/d/1ix2fgHbF15-5PIU9JBX3xG-apNC7yMIG/view?usp=sharing

[StefanoGrimaldi]

hello ypu can use a dax as follow: 

new measure =( (calculate(sum([total distributed per 100k]), date = today()) - calculate(sum([total distributed per 100k]), date = today()-1)) +(calculate(sum([total distributed per 100k]), date = today()-1) - calculate(sum([total distributed per 100k]), date = today()-2)) + .... and so on until last today its minus 7 ) / 7

that its one option, 

a second options would be using the move to move change of quick measure and change it up a little to make it per day. adding it in a graph with the last 7 days and getting a average line in the visual. 

[MFelix · Accepted solution]

HI @jovendeluna21 

Add the following measure to your calculation:

7days variation = 
[7 Day Rolling Average of Total Distribution per 100k]
    - CALCULATE (
        [7 Day Rolling Average of Total Distribution per 100k],
        FILTER (
            ALLSELECTED( us_state_vaccinations[date] ),
            us_state_vaccinations[date]
                = MAX ( us_state_vaccinations[date] ) - 1
        )
    )