Forum Discussion

Nilsoo's avatar
Nilsoo
Frequent Visitor
9 years ago
Solved

Time Range Filter: How to keep filtered values?

Hi, I have the following problem I have a data set containing Sales values of a specific date (my short table below should clarify the topic). I would like to use a time range filter that says how t...
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • NielsDecoene's avatar
    NielsDecoene
    9 years ago

    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 

    http://www.daxpatterns.com/cumulative-total/

Nilsoo's avatar
Nilsoo
Frequent Visitor
9 years ago

hey NilsDecoene,

 

thanks for introducing the Datesbetween function. I solved it now!
You need to create 2 measueres.

 

One that contains the all the Data up to the starting date of the filter and the second one that contains all data.

You need to apply the Datesbetween function for the first one. You set the start date on 01/01/1900 and the End Date to

min(Date).

 

Best.
Nils

Nilsoo's avatar
Nilsoo
Frequent Visitor
9 years ago

With this solution you only need one meassure that gives you the running total:

max. Date = Calculate( COUNT([Sales]);

Datesbetween('Sales'[Date].[Date]; Max('Sales'[Date]); 01/01/2100);
ALL('Sales'[Date])
)