Forum Discussion

SJHALANI's avatar
SJHALANI
Helper I
3 years ago
Solved

Convert hardcoded month to dynamic month, based on current month

Hi, I have written the below query: = Table.AddColumn(#"Removed Duplicates1", "Last Month of Funds", each if [PO Projections] = "No Funds" then "No Funds" else if [PO Projections] = "OK" then "...
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi SJHALANI ,

    You can replace them with these codes.

    current month(May 23):

    DateTime.ToText(DateTime.LocalNow(),[Format="MMM yy"])

     last month(Apr 23):

    DateTime.ToText(Date.AddMonths(DateTime.LocalNow(),-1),[Format="MMM yy"])

    next month(Jun 23):

    DateTime.ToText(Date.AddMonths(DateTime.LocalNow(),1),[Format="MMM yy"])

     

    Best Regards,
    Gao
    Community Support Team

     

    If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

    How to get your questions answered quickly --  How to provide sample data in the Power BI Forum

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi SJHALANI ,

You can replace them with these codes.

current month(May 23):

DateTime.ToText(DateTime.LocalNow(),[Format="MMM yy"])

 last month(Apr 23):

DateTime.ToText(Date.AddMonths(DateTime.LocalNow(),-1),[Format="MMM yy"])

next month(Jun 23):

DateTime.ToText(Date.AddMonths(DateTime.LocalNow(),1),[Format="MMM yy"])

 

Best Regards,
Gao
Community Support Team

 

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum