Dax related to last year starting to current date of last year

[Rimi_2095]

Hello Everyone,

I need to calculate sales of Last year from starting 01.01.2021 to current date of last year i.e 20.05.2021

In below dax I can calculate only for 01.01.2021 to 20.05.2021

Sales (LY) =

CALCULATE (

[USD_NetSales],

FILTER (

ALL ( Dim_Date ),

Dim_Date[Year] = YEAR ( TODAY () )-1

&& Dim_Date[Month] = MONTH ( TODAY () )

&& Dim_Date[Date] <= DATE( YEAR( TODAY () )-1, MONTH( TODAY() ), DAY( MAX(Dim_Date[Date])

)

)

))

Please guide me what modification shall I do to get sales for 01.01.2021 to 20.05.2021 instead of 01.05.2021 to 20.05.2021

@amitchandak @SpartaBI @Ashish_Mathur @DataInsights @Jihwan_Kim @johnt75 @ribisht17 

[Ashish_Mathur]

Hi,

Try this measure

Sales (LY) = CALCULATE([USD_NetSales],datesbetween(calendar[date],date(year(today())-1,1,1),edate(today(),-12)))

Hope this helps.

[Jihwan_Kim · Accepted solution]

Hi,

I will look into the filter context inside the CALCULATE function.

In the current DAX measure, there is one condition that sets month number as the same as today's month number.  Please try to remove that condition.

I hope this helps to rewrite a measure to show the result that you want.

Thanks.

[Rimi_2095]

Thank you Sir. It worked ..

[ribisht17]

@Rimi_2095 

(1) Solved: Total of last year on the same period as this year... - Microsoft Power BI Community

Last Year Sale =  CALCULATE(SUM(tablename[SalesAmount]), SAMEPERIODLASTYEAR(DateTable[Date]))

Regards,

Ritesh

[Rimi_2095]

Thank you for your response.. I will try this measures too.