Forum Discussion
Display data less than slicer date
You can create a calculated formula with a filter clause to get the filter on two different columns.
Test TWO filter Sales = ( VAR _Cuur_start = Generator[Report Start Date] VAR _Curr_END = Generator[Report End Date] return calculate(sum(Sales[Sales]),filter(sales,Sales[Order_Date] >= _Cuur_start && Sales[Delivery Date] <= _Curr_END )) )
In case, it does not work well with joined time dim, use this example to have independent date slicer
https://medium.com/chandakamit/power-bi-comparing-data-across-date-ranges-36be49b68613
Thanks For your reply,
I can display the measure (count) , but i cant display the underlying data in table.
like Ticket id, Ticket name, tickt status, created date. etc...
in table the data filtered by month(slicer date and month)
but i want display all data created date less than <slicer date. (Even the data created 2 years back and open status)
In the newer version you have filter pane in older version this there are page options. Page and Report Level filter. There add your date and in advance filter, you have before option, Hope this will work for your need
Yes, thanks
but i want to apply this value from slicer(selected value)
the filter pane it is allow satic value right?
Not very clear, what you say in the last update. Once you apply any value on filter pane, it will filter values in tables related to that table. The filter pane allows you to choose from a calendar and it will be available to users.