Calculate change from previous day

[Anonymous]

Hello, I have a report with a table showing "Total Open Actions" - using the filters 'Count of WO Status' and 'WO Status is Open' 

I have gotten a request to also show the change from the previous day, something like +1 or -3. 

I think the logical way to do this would be something that calculates the (sum of WO Status if status = Open) minus the Sum of WO status is status = open) from the previous day, I am now sure how to write this in DAX. any help appreciated! 

[Anonymous · Accepted solution]

I ended up finding a solution, 

I created 3 measures, 

1) Count of new Items

2) Count of Closed Items

3) Day over Day = Count of new Items Minus Count of Closed Items 

Then I added a table visual anf filtered it by date, Relative date is in last 1 day

[v-easonf-msft]

Hi, @Anonymous 

Not vrey clear.

show the change from the previous day, something like +1 or -3.

Do you expect to get the count of the status changes between today and yesterday?

Please share a sample file and you expected result. It will better help us understand your question.

Best Regards,
Community Support Team _ Eason

[Anonymous]

yes I would like to calculate the number of Open Items for the previous and compare it to the number of Open items for today,

for example

9/22 - Total open items = 722

9/23 - Total open items = 728

Open Items = +6

Trying to show the trend and direction for Open Items, If the total is going up or down

[negi007]

@Anonymous You can create a measure like below if you have date in your data

Open_Status_Today = CALCULATE(SUM('Open'[Open]),'Open'[Date]<=TODAY())-CALCULATE(SUM('Open'[Open]),'Open'[Date]<TODAY())

[amitchandak]

@Anonymous , do you have an open and close date? Because with the status we can not track past.

Also refer : https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-trend/ba-p/882970