Forum Discussion

Viraj16Agate's avatar
Viraj16Agate
Regular Visitor
5 years ago

Sales Last year

Hi,   I have sales data for last 3 year on different sales channel as below   SalesChannel      Date                Sales A                     01-10-2020        51454 A                     01-...
Tanushree_Kapse's avatar
Tanushree_Kapse
Icon for Impactful Individual rankImpactful Individual
5 years ago

Hi Viraj16Agate ,

 

Use below measures:

 

salesLY= CALCULATE(SUM(Table[Sales]), PARALLELPERIOD(Table[Date], -1, YEAR))
salesLY2= CALCULATE(SUM(Table[Sales]), PARALLELPERIOD(Table[Date], -2, YEAR))

 

Mark this as a solution, if I answered your question. Thanks