Forum Discussion
Filter Date Range using IF condition
Super UserIf you want to use in If and in the measure then you need use some aggregation
IF(a>b, Max(Dates)> x && max(Dates) <y)
if you in the filter you can avoid max on a date if X and Y are static
What you have done is possible in the column
refer example on my blog
Thanks for the response amitchandak
Also, I have a table visual on which I need to filter a specific range of dates based on the selection in another date slicer, how can we do it?
I have my main table(T1) with columns including Date column, I created a duplicate of the T1 as T2 and removed every column except Date column. So when I select a value from the date column in T2, I need to get the data from the SelectedDate till SelectedDate-30 in a table visual which contains the columns from T1.
How can we achieve this ?
Thanks
Kashyap.
v-lili6-msftCommunity Support
hi Anonymous
When you create a measure add this conditional in the formula as below:
eg.
Measure = CALCULATE(SUM('Table 1'[value]),FILTER('Table 1','Table 1'[Date]>=MAX('Table 2'[Date])-30&&'Table 1'[Date]<=MAX('Table 2'[Date])))In this simple sample, I will show the data from the SelectedDate till SelectedDate-7and here is sample pbix file, please try it.Regards,lin