Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
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' 

 

Jbarfield108_0-1600696634433.pngJbarfield108_1-1600696655306.png

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

Jbarfield108_0-1600868829057.png

 

View solution in original post

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

Jbarfield108_0-1600868829057.png

 

v-easonf-msft
Community Support
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

 

negi007
Community Champion
Community Champion

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

negi007_0-1600698003480.png

 




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



Proud to be a Super User!


Follow me on linkedin

amitchandak
Super User
Super User

@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

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.