Forum Discussion
Time Range Filter: How to keep filtered values?
So what you're looking for is a running total to that point in time?
So this would result to
Calculate( SUM(Sales);
Datesbetween(DateTable;Min(Date);Max(Date));
ALL(Date Table) Removes all filters on the date table
)
This should provide a running total, if my datesbetween statement is wrong
have a look at
Calculate( SUM(Sales);Datesbetween(DateTable;Min(Date);Max(Date)))
You'd have to use a filter with multi select.
Basically you will have to use Calculate Statement with a Datesbetween to specify a range of dates:
https://msdn.microsoft.com/en-us/library/ee634557.aspx
If I missed something tag me plz :)
Hey,
thanks for your response.
Unfortunately, this is not quite what I am looking for. Let me clarify this.On the same page I have on value that should show me the total sales upon an specific date e.g. 4.1 --> total sales = 65.
On this page I have another value which should show me the amount sales in the seletecd time range 2.1 - 4.1 --> #sales in time range = 45.
On the page there is the time range filter that allows me to adjsut the time period (see screenshot)
To calculate the amount of sales in the selected time range is easy. It's also no problem to calculate the overall total sales by surpressing all filters. However, calculating the total sales upon a specific date seems to be tricky since the time range filter, sorts out all the data that is not in the time range.
If I want to know what is the total sales on 4.1 I kneed to know what was the sales on 1.1 to add it to the #sales in time range.
But I don't know how to get these information. Anyone?So what you're looking for is a running total to that point in time?
So this would result to
Calculate( SUM(Sales);
Datesbetween(DateTable;Min(Date);Max(Date));
ALL(Date Table) Removes all filters on the date table
)
This should provide a running total, if my datesbetween statement is wrong
have a look at
Sorry but it is not working...
