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

     

wdx223_Daniel's avatar
wdx223_Daniel
Community Champion
3 years ago

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