Last year sales with monthly breakdown

[ajve22]

Hi,

I am using this measure to calculate last year sales:

Sales LY =

CALCULATE (

    SUM ( 'Sales fact'[Item_Value] ),

   PREVIOUSYEAR( ( 'Date (sales fact)'[Order Date] )

))

it shows correct last year sales but when place this measure on a table along with months, it shows last year's total sales every month. I need last year sales as a total sales but also which should show monthly breakdown.

Year 2023	Months	Last Year Sales
		Total : 1000
	January	200
	February	50
	March	150

Thanks

[AliNoorani]

Hi, 

Try using SAMEPERIODLASTYEAR() instead of PREVIOUSYEAR().

I think that will solve your problem. 

[ajve22]

@AliNoorani  it doesn't give total sales of last year, only shows last year's same month/period value. I need to show first total of last year then breakdown in the months.