Forum Discussion

stackover's avatar
stackover
Frequent Visitor
2 years ago
Solved

Combining running totals with selected date value

Hi guys. How are you doing? It has been a week that I am trying to do the following. I hope you guys can help me.   - I have two running totals. One is a baseline and it should be static (problem n...
Need Help
stackover's avatar
stackover
Frequent Visitor
2 years ago

Thanks @Ibendlin, but I think I am still not able to explain. See if the table can help you to understand my intent.


I did the following measure but it is not working. Looks like that the measure is not detecting the selected slicer value.

RT-Combined = 
VAR MaxDate = MAX ('Date_List'[Date])
VAR SelectedSlicerDate = MAX(DateSlider[Date])
VAR Result = 
CALCULATE ( 
    SUM(Project_Database[Value]),
    Date_List[Date] <= SelectedSlicerDate
) +
CALCULATE ( 
    SUM(Project_Baseline[Value]),
    Date_List[Date] > SelectedSlicerDate && 'Date_List'[Date] <= MaxDate
)
RETURN Result



 

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
2 years ago

Yeah, still nothing.  No idea where you are going with this. Maybe some business context?