Forum Discussion
Filtering Table based on Valid After and Valid Before dates
Create a measure like this and add to your table
Measure = var _min = date(2020,02,01) var _max = date(2020,02,29) return CALCULATE(Min(Sheet1[Price]),Sheet1[Price End Date]>=_min , Sheet1[Price Start Date]<=_max)The min and max can come from your slicer
min = minx(slicer1,slicer1[Date])
max= maxx(slicer1,slicer1[Date])
Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution.
In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blogs -Decoding Direct Query - Time Intelligence, Winner Coloring on MAP, HR Analytics, Power BI Working with Non-Standard TimeAnd Comparing Data Across Date Ranges
Connect on Linkedin
Create a measure like this and add to your table
Measure =
var _min = date(2020,02,01)
var _max = date(2020,02,29)
return
CALCULATE(Min(Sheet1[Price]),Sheet1[Price End Date]>=_min , Sheet1[Price Start Date]<=_max)
The min and max can come from your slicer
min = minx(slicer1,slicer1[Date])
max= maxx(slicer1,slicer1[Date])
Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution.
In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blogs -Decoding Direct Query - Time Intelligence, Winner Coloring on MAP, HR Analytics, Power BI Working with Non-Standard TimeAnd Comparing Data Across Date Ranges
Connect on Linkedin
