Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Dynamic Date IF Statement

Hi,    I'm trying to do a simple IF Statment but it doesn't seem to work; I'm trying to created a calculate column to use as a customer filter.    I'm looking at 3 Columns as listed below:   (...
Need Help
  • v-juanli-msft's avatar
    v-juanli-msft
    6 years ago

    Hi Anonymous 

    Do you check my answers above?

    these are all measures instead of columns

    max selected = MAX('calendar'[Date])

Measure = IF([max selected]>MAX([start])&&[max selected]<=MAX([end]),"Include","exclude")

     

    Best Regards

    Maggie

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi nandukrishnavs , 

 

Unfortantly this bough back the same results I got where it seems to not be applying the logic. 

 

 

Thanks 

Rob 

 

v-juanli-msft's avatar
v-juanli-msft
Community Support
6 years ago

Hi Anonymous 

It seems your slicer set as "before",

so the range you select is date 2017/10/1~2018/9/1

For the first line 2018/8/1~2018/11/12, it is not include in the selected date range.

 

Best Regards

Maggie

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.