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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
DrewZain2345
New Member

Iterate % Complete Over Days

 

I'm trying to create a line graph that shows the "calendar percent complete" between two dates. (Iterate a percent complete calculation over days between two dates)

DrewZain2345_0-1696350706341.png


I have my calendar percent complete measure:

Calendar Percent Complete =
VAR _DaysSinceStart = DATEDIFF ( MIN ( 'Contract'[Start Date] ), TODAY (), DAY )
VAR _Duration = DATEDIFF ( MIN ( 'Contract'[Start Date] ), MAX ( 'Portfolio'[Completion] ), DAY )
RETURN
DIVIDE (
    _DaysSinceStart, _Duration
)

And I started with this:

IterativeMeasure =
CALCULATE(
    [Calendar Percent Complete],
    FILTER(
        ALL('Date'[Date]),
        'Date'[Date] >= MIN('Contract'[Start Date]) &&
        'Date'[Date] <= MAX('Portfolio'[Completion])
    )
)

Getting these results:

DrewZain2345_1-1696351107245.png

 

 

Relationship issues?

1 REPLY 1
amitchandak
Super User
Super User

@DrewZain2345 , Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

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

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.