How to get the difference between cumulative sales of 2017 and cumulative sales of 2016

[Charam]

Hi,

   I'm getting trouble to find out the differnece between cumulative sales of 2017 and 2016. I've Invoice date and total net price in my table. Can you guys help me out to get this done.

Thank you

[Ashish_Mathur · Accepted solution]

Hi,

Try this

1. Create a calendar table with running dates
2. In that table, extract Year in another column using the =YEAR(Calendar[Date]) formula
3. Create a relationship from the Date column of your Data Table to the Date column of your Calendar table
4. Drag the Year column from the Calendar table to your visual
5. Write the following calculated field formula

Total Revenue=SUM(Data[Amount])

=CALCULATE([Total Revenue],PREVIOUSYEAR(Calendar[Date]))

Hope this helps.

[Ashish_Mathur · Accepted solution]

Hi,

Try this

1. Create a calendar table with running dates
2. In that table, extract Year in another column using the =YEAR(Calendar[Date]) formula
3. Create a relationship from the Date column of your Data Table to the Date column of your Calendar table
4. Drag the Year column from the Calendar table to your visual
5. Write the following calculated field formula

Total Revenue=SUM(Data[Amount])

=CALCULATE([Total Revenue],PREVIOUSYEAR(Calendar[Date]))

Hope this helps.

[Charam · Accepted solution]

That Works Perfect.. Thank you..!!

[Ashish_Mathur]

You are welcome.

[Charam]

Hi Ashish,

   If you don't mind, Can you help me with the below link..

https://community.powerbi.com/t5/Desktop/how-to-get-customers-have-sales-more-than-threshold-amount/...

Thank you..