Forum Discussion

Stuartw1988's avatar
Stuartw1988
New Member
4 years ago
Solved

Relative Dates

Hi,   I am using filters to establish list of customers who have certain last order dates.  I have used relative date feature to get customers who have orders in last 30 days - but how can I use th...
Need Help
  • v-xiaotang's avatar
    v-xiaotang
    4 years ago

    Hi Stuartw1988 

    You can try this method

    (1) create the table below, use it in slicer

    (2) create the measure, use it to filter table

    filter = IF(MIN('FactTable'[Start Date])<=SlicerDays[SlicerDate1] && MIN('FactTable'[Start Date])>=[SlicerDate2],1,0)

    you can put it in visual level filter,

    For more please check the sample file attached below.

     

    Best Regards,

    Community Support Team _Tang

    If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

v-xiaotang's avatar
v-xiaotang
Community Support
4 years ago

Hi Stuartw1988 

You can try this method

(1) create the table below, use it in slicer

(2) create the measure, use it to filter table

filter = IF(MIN('FactTable'[Start Date])<=SlicerDays[SlicerDate1] && MIN('FactTable'[Start Date])>=[SlicerDate2],1,0)

you can put it in visual level filter,

For more please check the sample file attached below.

 

Best Regards,

Community Support Team _Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.