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
Apply difference to multiple IDs within a group in DAX
I have a table with daily Consumption totals and a fixed Capacity amount per ID. I want the Consumption value to be subtracted from the "first" ID's Capacity until it is 0, and then subtract the remaining amount from the next ID within the group. Desired output is the Amount Left column below: Date Group ID Capacity Consumption Amount Left 1/1/2019 A 1 10 8 2 1/1/2019 A 2 15 8 15 1/1/2019 A 3 15 8 15 1/2/2019 A 1 10 9 0 1/2/2019 A 2 15 9 4 1/2/2019 A 3 15 9 15 1/3/2019 A 1 10 10 0 1/3/2019 A 2 15 10 0 1/3/2019 A 3 15 10 1
