Rollup the date based on condition
Hello Everyone I would like to achieve the rollup for each Category - with the max date where color is not equal to red Below is the sample data - I am getting the wrong highlighted dates - (it should filter out the date where it is red) Result Expected For highlighted date- A - 11/18/2021 B - 10/11/2021 Thanks in advance. Would really appreciate the help.Adding 2 custom lines to line and stacked column chart
I currently have a pareto chart by number of cases per event date. I'm trying to add a rolling 7 day average calculation to this but I keep getting: Where I was hoping to have something like this? I'm currently running my 7 day rolling average by [Event Date]: 7 Day Rolling Average - Notification Date = CALCULATE(SUM('Sheet1'[Epi Date Count]),DATESINPERIOD('Sheet1'[Event Date],LASTDATE('Sheet1'[Event Date]),7,DAY)) / CALCULATE(DISTINCTCOUNT('Sheet1'[Event Date]),DATESINPERIOD('Sheet1'[Event Date],LASTDATE('Sheet1'[Event Date]),7,DAY)) Is there any way this can be done? Thanks in advance Please find file attached https://www.dropbox.com/s/c3hfci8jabydxv1/Pareto.pbix?dl=0Sum Rolling Last 5 rows of dates
Hello everyone, I have an issue and i'm stuck. I try to make a sum of PTS of the last fives dates. As you can see, it's rolling by the following dates. For the rows 5,4,3,2,1 . I'm just making a cumulate until I have 5 rows of dates. Thanks a lot for your help. Regards Kevin
