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

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
beynelmilel
Frequent Visitor

Count decreases by increment amount and and last week's value cannot be calculated

Hello, I tried to make a measure.
I am trying to find the target and actual measurements by counting the dates in a certain range as burn down.
But I miscalculated the realised column. actually I needed to make a calculation like in the red box. and I'm trying to max-realize using the realized data of the previous week, as in the area shown with the green lines.

"Red line area = max - release"

beynelmilel_1-1669465526059.png

 

beynelmilel_0-1669465293537.png

example data:

beynelmilel_2-1669466078250.png

 

 

1 REPLY 1
lbendlin
Super User
Super User

Please provide sanitized sample data that fully covers your issue.
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
Please show the expected outcome based on the sample data you provided.

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

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

Top Kudoed Authors