Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I'm using this formula to get the count of the sales dates
Count({< DateType = {'Sales Date'}>} [Account Number]), how can i add the average here to get the average daily sales count by year and month .
Create a chart or table where you have Year (and Month) as dimensions.
To calculate the average sales amount you need to calculate your sales amount, let's assume that it is Sum([Sales Amount]), and divide it by the number of days associated to your dimension values, Count({< DateType = {'Sales Date'}>} [Account Number]).
Your expression will look something like this.
Sum([Sales Amount]) / Count({< DateType = {'Sales Date'}>} [Account Number])