Evolution of value per id filtering by date
Hi, I have been investigating on the forum but still have some issues. I have a table like this: Id Date Value 1 1/1/2020 Prospect 1 2/2/2020 Lead 1 5/5/2020 Opportunity 2 3/3/2020 Prospect 2 4/4/2020 Lead 2 7/7/2020 Opportunity I need a measure that shows the last value by id filtering by month. For example, if I select march/2020 I need to have something like: Id value 1 Lead 2 Prospect Then, I need to display a chart that shows the number of distinct id´s per value filtering by month If I select 5/5/2020, I need to see something like: Value Count of id Prospect 0 Lead 1 Opportunity 1 This means, we count the number of id´s per value, depending on the last value of an id at a certain date