cumulate Measure Values Between two Dates

[scorpi73]

Hello there,

the cu.m-Measure should cumulate the Soll Measure Values between the Blank IST Values:

IF the IST isnt Blank then it should pass the Soll Value to cu.m

Bonus Question: how could i change the condition of the cu.m Measure, if i would cumulate after the second day of Blank IST Values.  like this :

https://www.dropbox.com/s/93qvszfrur161kl/sample_Dates%20between.pbix?dl=0

Thank You guys:)

[ribisht17]

Did it help you?

Regards,

Ritesh

[ribisht17 · Accepted solution]

@scorpi73  You can download the solution here, I changed IST to Column 

https://drive.google.com/drive/folders/1s_9sdFOqSK0EwBLOU4hFOeDXjyGagczH?usp=sharing

Mark my post as a solution if it helped you| Gentlemen & Ladies|Munde and Kudis| I like your Kudos!! !!
My You Tube Channel !! Connect on Linkedin || Power BI for Tableau Users 

[Daryl-Lynch-Bzy]

@scorpi73 - I would suggest watching the following video by Alberto.  Implementing running total from arbitrary dates in DAX - Unplugged #34 - YouTube  - It will help you understand the filter context for the running total, and how you can filter for the blank dates.

[ribisht17]

@scorpi73 ,

Step 1: 

Cumulative Total =

CALCULATE (

SUM(**bleep**[Soll]),

FILTER (

ALL( **bleep** ),

**bleep**[Date] <= MAX ( **bleep**[Date]) && **bleep**[IST] = MAX(**bleep**[IST])

)

)

2. 

Condition = IF(ISBLANK(min(**bleep**[IST]) ),[Cumulative Total],sum(**bleep**[Soll]))

3. 

When you say ,Measure should cumulate the Soll Measure Values between the Blank IST Values:

Should not it start with 87 ?

Regards,

Ritesh

[scorpi73]

Hey Ritesh, thank you for your effort.
the cu.m is a measure not a Table. i did not manage to apply you Measure to my File.

i attached a PBIX File, to show my Problem

https://www.dropbox.com/s/93qvszfrur161kl/sample_Dates%20between.pbix?dl=0