Forum Discussion
Problem with filtering dates
Hello
I have a table with my equipment and oil analysis dates, and another table with oil changes.
Oil changes
Results table
In my line chart visual I see the results of all dates, but I only want results to appear from the date of change. If I implement a segmenter I would have to manually change the date depending on the change of each team, I want that to be automatic and not have to use the segmenter.
Is it possible to do that?
1 Reply
Syndicate_Admin , You can filter that
example
calculate(Sum(Table1[Value]), filter(Table1, Table[Date] in values(Table2[date])))
