cumulative line chart: different results over different timelines?

[Dave_Delfino]

Hello everybody and thank you in advance for helping me out here!

I'm trying to extend the shown line-charts with an "actual hours used" curve (shown as yellow) comming from the [as-is Date (release)] column (found in the "PDL2" table)

.

There are a few problems with that particular graph:

tha measure is calculated the exact same way as the [cumulated sum effort buffer](green)and the [aggriegierte sum Effort](black)

But the yellow graph won't cumulate when I'm trying to plot it over [Date]. It also doesn't start on the 1st of January.

So I tried plotting it over the [as-is Date (release)]-column in a seperate line-chart

plotting it over the [as-is Date (release)] column seems to work but has a weird offset (about 34354 hours). However, plotting it over [Date] results in an uncumulated graph and a shifted start-date again.

Has anybody encountered this kind of problem before or has any ideas? Again, thank you in advance!

In the following i'll show a few background-information:

[v-chuncz-msft]

@Dave_Delfino,

You may try dragging date from a calendar table and apply virtual relationship in DAX to add an appropriate measure.

[Dave_Delfino · Accepted solution]

Hello @v-chuncz-msft,

i actually solved the problem earlier.

solved problem with a few extra measures

the problem was that i tried to force the [As-Is Date (Release)] column into the chart by using the following code while all the other graphs are using the [Date] column for plotting:

actual effort = CALCULATE(
[SUM EFFORT 2];Filter(ALLNOBLANKROW([As-Is Date (Release)]);[As-Is Date (Release)]<=max([As-Is Date (Release)])))

The Solution was to let Power Bi "map" the As-Is Date Column onto the 'Zeitsreifen'[Date] column by it self using the relationship i established in the "relation-screen" and the following code which doesn't contain the wanted [As-Is Date(Release)] column at all:

actual effort = CALCULATE(
[SUM EFFORT 2];Filter(ALLNOBLANKROW('Zeitstreifen'[Date]);Zeitstreifen[Date]<=max(Zeitstreifen[Date])))

I needed a good amount of time understanding this "maping"-thing, but now everything seems fine 🙂

nevertheless, thanks for the help 🙂

David