Hi,
I am trying to work out my net adds for the month.
- In excel I filter on the Start Date column i.e. October dates only.
- I then need to sum the quantity column.
- Leaving the filter on the Start Date column I then filter on the service End Date Column for October dates only. – I then sum the quantity column
- I now have two sum figures
- I take away the SumQuantity for Start Date & SumQuantity for Service End Date to work out my net adds
Can anyone advise which would be the best Dax formula for this?
I can post data if need be.