Sameperiodlastyear till to date based on selection in year and month selection

[PowerBigginer]

Hello Everyone,

I'm new to this forum and need help with a DAX calculation. When I select a year in the slicer, I want to see the sales amount for the corresponding year of the previous year. If I select both a year and a month, I'm looking for the sales amount for the same month of the previous year. Additionally, if I choose the current month in the slicer, I want to see the total sales amount from the previous year up to the selected date which means till 23rd of Jan 2023.

If I select 2023 in year and Jan in month slicer I want to see the sales amount for the entire month of January 2022.

I've created a DAX formula that works correctly for the current month. However, when I select January 2023, the result only includes data until January 22, 2022. My goal is to retrieve the entire sales data for January 2022 when selecting January 2023 in the year and month slicers.

Here is my Dax

CALCULATE(

SUM('tbl_Sales Header'[FINANCE_AMOUNT]),

SAMEPERIODLASTYEAR(

DATESYTD('Calendar Table'[Date])

),

FILTER(

ALL('Calendar Table'),

'Calendar Table'[MonthNum] <= (MONTH(NOW())-1)

)

)+

CALCULATE(

SUM('tbl_Sales Header'[FINANCE_AMOUNT]),

SAMEPERIODLASTYEAR(

DATESYTD('Calendar Table'[Date])

),

FILTER(

ALL('Calendar Table'),

'Calendar Table'[MonthNum] = MONTH(NOW())

&& DAY('Calendar Table'[Date]) <= DAY(NOW())

)

)

I appreciate any guidance or corrections to my DAX formula.

[PowerBigginer]

@Fowmy  Thanks For your responce this is working fine for last years(if I select 2023 Jan I am getting correct result for 2022 Jan) but when I select current Month value is showing wrong and when I select feb 2024 I am getting huge amount My requirement is when I select current month the previous year value should get till the date. If I select Feb also I should get the value last year of till the date(Till Jan 23). 

[Fowmy]

@PowerBigginer 

Follow this patter, it caluclates the sales up to the date where there is sales for current and previous periods, it could be month, year, week and so on:

MoM = 

VAR __CM = [Sales Amount]
VAR __Period = DATEADD( DATESBETWEEN( 'Date'[Date] , MIN( 'Date'[Date] ) , MAX( 'Sales'[Order Date] ) ) , -1 , YEAR )
VAR __LYSM = CALCULATE( [Sales Amount] ,__Period )
RETURN
    __LYSM