Forum Discussion
dax
i want to show last year sales, this yar sales from total sales but according to the fiscal year that is already created in the database (eg 22-23, 23-24) ...... i have tried different measures but i...
explain how these numbers got it
Categorylast year salesthis year
Aircare 10945577,49 11584772,68 you need to write the following
AMO = SUM('share data 1'[Sum of Retailing]) lastYear = CALCULATE([AMO],'share data 1'[Fiscal] ="22-23") NowYear = CALCULATE([AMO],'share data 1'[Fiscal] ="23-24") % growth = DIVIDE([NowYear],[lastYear])-1
explain how these numbers got it
Categorylast year salesthis year
| Aircare | 10945577,49 | 11584772,68 |