Forum Discussion

Divya904's avatar
Divya904
Helper III
8 years ago
Solved

Filtering a table with user entered input date

Hi Experts   Please help me to find how we can filter a table based on user entered date.   I have created a new 'Date' table in Power BI which gives me a 'date field'.  I have created a slicer u...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    8 years ago

    Hi,

     

    Ensure that the relationship is from the OrderDate column of the Sales Table to the Date column of the Calendar Table.  Also, the relationship status should be active.  Furthermore, you should be able to simplify your formula to:

     

    =if([PostingDate - User Input Date]<0,CALCULATE(Sum('Sales'[Amount ]),[WhatIsTheAge]>=1,[WhatIsTheAge]<31,[Item Status] = "O"),0)

Divya904's avatar
Divya904
Helper III
8 years ago

Hi Ashish

 

Thanks for the reply.

The relationship has been set before.

In the following Measure:

if([PostingDate - User Input Date]<0,CALCULATE(Sum('Sales'[Amount ]),[WhatIsTheAge]>=1,[WhatIsTheAge]<31,[Item Status] = "O"),0)

Just wanted to confirm, when the user inputs a date in the filter, will it go in the above measure calculation and this calc will work accordingly.

Or there is any other way to filter around the user input date.

 

Thanks

Ashish_Mathur's avatar
Ashish_Mathur
Super User
8 years ago

Hi,

 

Yes, the measure should recalculate when the user select a certain date in the filter.