Get certified for free when you join Fabric Data Days 2026 and dive into Fabric, Power BI, SQL, AI, and other essential data skills.
Join nowData Days is here! Join us now for 60+ days of learning, challenges, and connection. Learn more
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:
Visual for Yesterday:
For Previous Days:
Would request you to please suggest the changes to get the correct visual of yesterday data .
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...
Don't miss out on Data Days, June 15 through August 7. Learn Fabric, Power BI, SQL, AI and more.
Check out the May 2026 Power BI update to learn about new features.
| User | Count |
|---|---|
| 2 | |
| 2 | |
| 1 | |
| 1 | |
| 1 |