Forum Discussion
Show data between 2 Date Filters
Hi Shadowestien ,
Delete the relationship between the tables, and then try the following formula to put the value of measure into the filter on this visual to show the result as 1.
If the problem is still not resolved, please point it out or provide test pbix file. Looking forward to your reply.
Best Regards,
Henry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Shadowestien ,
Try a formula similar to the following, select the date values in each of the two slicers and filter out the corresponding values that meet the specified date.
M =
VAR a =
SELECTEDVALUE ( slicer[Start] )
VAR b =
SELECTEDVALUE ( slicer[End] )
RETURN
CALCULATE (
MAX ( 'Table_'[Value] ),
FILTER (
ALL ( Table_ ),
MAX ( 'Table'[Date] ) <= b
&& MAX ( 'Table_'[Value] ) >= a
)
)
If the problem is still not resolved, are you able to provide some test data (remove sensitive information) to facilitate me to answer for you as soon as possible. Looking forward to your feedback.
Best Regards,
Henry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, I'm having the same initial problem. My objective is show the data between two selected dates (start date and end date), both selected by different filters.
However, I could not implement this measure correctly. Could you share the .pbix file with this example?
Sorry for the English, I'm Brazilian. Thanks.