dax

[Anonymous]

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 ?

[Ahmedx · Accepted solution]

explain how these numbers got it

Categorylast year salesthis year

Aircare

10945577,49

11584772,68

[Ahmedx · Accepted solution]

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

[Ahmedx]

Share some data to work with (in a format the can be pasted in an MS Excel file) and show the expected result

[Anonymous]

last year sales = CALCULATE(SUM(PSR[Retailing]),SAMEPERIODLASTYEAR('Dates'[Dates].[Date]))

i have used this one but its not showing same result

[Anonymous]

[Ahmedx · Accepted solution]

explain how these numbers got it

Categorylast year salesthis year

Aircare

10945577,49

11584772,68

[Ahmedx]

in a format the can be pasted in an MS Excel file or pbix