previous date

[faheem_Latif_BI]

Hi ,

Im using this for current month and year which is working fine.

currentdate=(Date.ToText(DateTime.Date(DateTime.LocalNow()),"MMyyyy"))

Output is =112022

now i want to get prevoius month 

Pdate=(Date.ToText(DateTime.Date(DateTime.LocalNow()),"MMyyyy")) -1 

but its not working please advise.

[wdx223_Daniel]

Pdate=Date.ToText(Date.AddMonths(DateTime.Date(DateTime.LocalNow()),-1),"MMyyyy")) 

[faheem_Latif_BI]

Thanks for reply im using like this but giving me error 

Table.AddColumn(#"Added Custom", "Previous_MonthYear", each Date.ToText(Text.PadStart(Text.From(Date.Month(DateTime.LocalNow())-1),2,"0")&Text.From(Date.Year(DateTime.LocalNow())),"MMyyyy"))

[Samarth_18]

Could you please share the error?

[faheem_Latif_BI]

[Samarth_18]

@faheem_Latif_BI Please try this:-

#"Added Custom" = Table.AddColumn(#"Added Custom", "Previous_MonthYear", each Text.PadStart( Text.From(Date.Month(DateTime.LocalNow())-1),2,"0")&Text.From(Date.Year(DateTime.LocalNow())))
in
    #"Added Custom"

[faheem_Latif_BI]

smart 18

UR star

[Samarth_18 · Accepted solution]

Hi @faheem_Latif_BI ,

Please try below mquery code in custom column:-

Text.PadStart(Text.From(Date.Month(DateTime.LocalNow())-1),2,"0")&Text.From(Date.Year(DateTime.LocalNow()))