Forum Discussion
Solved
cumulate Measure Values Between two Dates
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...
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
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
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