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

Data Days is here! Join us now for 60+ days of learning, challenges, and connection. Learn more

Reply
Anonymous
Not applicable

Not Getting Required Running Total for Jobs that got completed yesterday

I am trying to visualize Jobs Running each day using running total so that it can aggregate all values according to time it get completed on that particular day. However for Today and previous days it is working fine and aggregating the value as required except yesterday.

For yesterday date it is not aggregating the value according the time.

I have use this measure to visualize running total:

 

Finished running total in START_DATE =
CALCULATE(
SUM('Query1'[Finished]),
FILTER(
ALLSELECTED('Query1'[START_DATE]),
ISONORAFTER('Query1'[START_DATE], MAX('Query1'[START_DATE]), DESC)
)
)

 

 

Visual for Today Running Total:

Jack_Karim_0-1695610323493.png

Visual for Yesterday:

Jack_Karim_1-1695610373341.png

For Previous Days:

Jack_Karim_2-1695610512583.png

Would request you to please suggest the changes to get the correct visual of yesterday data .

 

 

 

1 REPLY 1
lbendlin
Super User
Super User

Please provide sample data (with sensitive information removed) that covers your issue or question completely, in a usable format (not as a screenshot). Leave out anything not related to the issue.
https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...
Please show the expected outcome based on the sample data you provided.

https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...

Helpful resources

Announcements
Fabric Data Days is here Carousel

Fabric Data Days 2026

Don't miss out on Data Days, June 15 through August 7. Learn Fabric, Power BI, SQL, AI and more.

May Power BI Update Carousel

Power BI Monthly Update - May 2026

Check out the May 2026 Power BI update to learn about new features.

Power BI DataViz World Championships carousel

Power BI DataViz World Championships - June 2026

A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.

Top Kudoed Authors