Forum Discussion
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...
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, Can you share the end result that you are expecting along with some dummy data