cancel
Showing results for
Did you mean:
Anonymous
Not applicable

## Calculate change from previous day

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!

1 ACCEPTED SOLUTION
Anonymous
Not applicable

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

5 REPLIES 5
Anonymous
Not applicable

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

Community Support

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
Not applicable

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

Super User

@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())

Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Super User

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

Announcements

#### Power BI Community Changes

Check out the changes to the Power BI Community announced at Build.

#### Power BI May 2023 Update

Find out more about the May 2023 update.

#### Data Stories Gallery

Visit our Data Stories Gallery and give kudos to your favorite Data Stories.

Top Solution Authors
Top Kudoed Authors