Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
Solved! Go to Solution.
Hi,
Try this
Total Revenue=SUM(Data[Amount])
=CALCULATE([Total Revenue],PREVIOUSYEAR(Calendar[Date]))
Hope this helps.
Hi,
Try this
Total Revenue=SUM(Data[Amount])
=CALCULATE([Total Revenue],PREVIOUSYEAR(Calendar[Date]))
Hope this helps.
That Works Perfect.. Thank you..!!
You are welcome.
Hi Ashish,
If you don't mind, Can you help me with the below link..
Thank you..
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
63 |
User | Count |
---|---|
135 | |
126 | |
110 | |
70 | |
61 |