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 its not matching this fiscal year. Also can i display Yoy percentage with this this fiscal year ?
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
6 Replies
Share some data to work with (in a format the can be pasted in an MS Excel file) and show the expected result
in a format the can be pasted in an MS Excel file or pbix
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