Forum Discussion
Calculating a Total Based on Start/End Dates
I have a data set that includes Start/End Dates, Site, Object, and ObjectAttributeX (a number equal to or less than 1). I need to calculate Total ObjectAttributeX for a Site. If an Object's Attribu...
Greg_DecklerI'm wondering if I confused the issue by calling the column I'm trying to sum "time"?
I've editted my post above.
My issue is when I sum March 2020 I need a formula that uses (for example) the first line for Object D (1.00) and when I sum April 2020 I need it to use the second line for Object D (0.80). I don't think time/duration plays into it?
If this is all you need I believe you can create a measure using the SUMX function: https://docs.microsoft.com/en-us/dax/sumx-function-dax
I'm not sure why you are using the End date for some sums and the start date for others. This is the part that needs clarification.