Forum Discussion

Klaus's avatar
Klaus
Regular Visitor
8 years ago
Solved

Dynamic filtering of rows using a parameter

Hello,   I have a table with two attributes: [order_dates] and [sales]. I want to filter rows fitting the following condition: number of days between MAX(Order_Date) and order_date >= X. X should...
Need Help
  • BILASolution's avatar
    BILASolution
    8 years ago

    Hi Klaus

     

    You can try this...

     

    1. Create a new calculated column (days)

     

    days = DATEDIFF(Sales[OrderDate];MAX(Sales[OrderDate]);DAY)

     

     

     

    2. Finally, Use it as an slicer. Look the picture below.

     

     

    NOTE: The right side of the slicer must be in the right limit

     

    I hope this helps

    Regards

  • Klaus's avatar
    Klaus
    8 years ago

    Thank you a lot!

     

    You are right. In this case a parameter is absolutely not necessary.

     

    Your suggestion works perfectly.

     

    Kindest regards

BILASolution's avatar
BILASolution
Solution Specialist
8 years ago

Hi Klaus

 

You can try this...

 

1. Create a new calculated column (days)

 

days = DATEDIFF(Sales[OrderDate];MAX(Sales[OrderDate]);DAY)

 

 

 

2. Finally, Use it as an slicer. Look the picture below.

 

 

NOTE: The right side of the slicer must be in the right limit

 

I hope this helps

Regards

Klaus's avatar
Klaus
Regular Visitor
8 years ago

Thank you a lot!

 

You are right. In this case a parameter is absolutely not necessary.

 

Your suggestion works perfectly.

 

Kindest regards