Forum Discussion

faheem_Latif_BI's avatar
faheem_Latif_BI
Helper I
3 years ago
Solved

previous date

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.

 

 

Need Help
  • Samarth_18's avatar
    Samarth_18
    3 years ago

    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()))

     

7 Replies

  • Samarth_18's avatar
    Samarth_18
    Community Champion
    3 years ago

    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()))

     

  • faheem_Latif_BI's avatar
    faheem_Latif_BI
    Helper I
    3 years ago

    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"))

  • wdx223_Daniel's avatar
    wdx223_Daniel
    Community Champion
    3 years ago

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