M Query for Previous Year Till Date

[Anonymous]

Hello,

I have a requirement to show the PYTD in data which i need to achieve by adding into M query. 

I tried the below approach and its giving the previous year but only for two months:

#"FILTER"=Table.SelectRows(#"Changed Type",each ([Transaction Detail.Production Period] >=#date(Date.Year(DateTime.LocalNow()) -1 , Date.Month(DateTime.LocalNow())-1, 1))
and ([Transaction Detail.Production Period] <#date(Date.Year(DateTime.LocalNow()) -1 , Date.Month(DateTime.LocalNow())+1, 1)))
in
#"FILTER"

I need to show it for all months from Jan 2021 to Dec 2021.

Kindly help.

Thanks 

[Anonymous]

Hi,
How can i get all three in one like : 
MTD, YTD, PYMTD and PYYTD

[HotChilli]

You could hardcode the months. 1 and 12

Is it really previous year To date or is it subtract 1 year and return the calendar year's data?

[amitchandak · Accepted solution]

@Anonymous , As you need full year, You can compare to year -1

#"FILTER"=Table.SelectRows(#"Changed Type",each (Date.Year([Transaction Detail.Production Period]) =Date.Year(DateTime.LocalNow()) -1 ))
in
#"FILTER"