Create Measure for calculating daily sales from cumulative sales

[Anonymous]

Hi,

Anyone could help me out to obtain daily sales from cumulative sales as shown alongside. I want to be able to visualise monthly trend in daily sales in my line chart.

Thanks

[Jihwan_Kim]

Hi, @Anonymous 

I created a sample pbix file like the below picture.

Please check the link down below whether it is what you are looking for.

All measures are in the sample pbix file.

https://www.dropbox.com/s/odbpvv2d5xjuhy6/kunal.pbix?dl=0 

Hi, My name is Jihwan Kim.

If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

[Anonymous]

@Jihwan_Kim , each date sales gives a wrong total. It should sum upto 276.

I tried using below DAX code but doesn't help,

Daily Sales=

var current_day= max(Sales[Date])

var current_day_sales= calculate(sum(Sales[Amount]), Sales[Date]= current_day)

var previous_day_sales= calculate(sum(Sales[Amount]),PREVIOUSDAY(Sales[Date]))

return

current_day_sales-previous_day_sales

[Jihwan_Kim · Accepted solution]

Hi, @Anonymous 

Sorry for not taking care of the total line.

please check the below DAX measure and the link down below.

each date sales =
IF (
ISFILTERED ( 'Table'[Date] ),
[Cumulate Sales Total] - [Previous Date Sales],
SUMX (
VALUES ( 'Table'[Date] ),
[Cumulate Sales Total] - [Previous Date Sales]
)
)

https://www.dropbox.com/s/odbpvv2d5xjuhy6/kunal.pbix?dl=0 

Hi, My name is Jihwan Kim.

If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

[amitchandak]

@Anonymous , Create a new column as

new column =
var _max = maxx(filter(Table, [Date] <earlier([date])),[Date])
return
[cumm_sales] - maxx(filter(Table, Table[Date] =_max),[cumm_sales])

if all dates are continuous then

new column =
[cumm_sales] - maxx(filter(Table, Table[Date] =earlier([date]) -1 ),[cumm_sales])

[Anonymous]

Thanks @amitchandak ,

Any help on the measure will be much appreciated. Columns using DAX will take huge space with my data.