Forum Discussion
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 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:)
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
5 Replies
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
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.
Did it help you?
Regards,
Ritesh
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
