Hope all is well,
Please can you help, I have a table containing essentially sites with columns of dates signifying when a certain piece of equipment was installed ( there are only 5 types, but can be installed on varying different and not always in the same order).
I have another table that has calculated the monthly average usage for each of these equipment groupings.
So the final piece of the puzzle it to firstly count on a mountly basis which equipment group each sites falls into, the extrapolate up to calculate the average usage (site count * Average Usage) per equipment group.
I have tried various different dax formulas (countx, calculate with filter where equipment date >= calender dates), none of which are giving me what i need
Any help on this would be most appreciated