Forum Discussion

Jo74's avatar
Jo74
Regular Visitor
1 year ago
Solved

Powerquery add column If date in another column is more than a year ago

Hi all I am fairly new to Power Query and need some help please.  I have a column with a created date and if it is more than a year old the calculation is based on another column.   So If created ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi Jo74 ,

That is something that can be done using Microsoft Power Query  Formula language(informally called as M language).
Follow this documentation to learn more about M query
Power Query M formula language reference - PowerQuery M | Microsoft Learn

As mentioned by OwenAuger, the provided M query will help you in creating a new column that you want.

Please reach out to us if you have any further quries related to the provided M query or in power query in general
Dont forget to mark the helpful solution so as to help other community members

If my response(s) assisted you in any way, don't forget to give "Kudos"

Thanks and Regards



  • Jo74's avatar
    Jo74
    Regular Visitor
    1 year ago

    Thank you for your help.  I did not manage to get it to work and have just added a simple column after the powerquery in Excel.  Afraid this is outside my realm of understanding!

    • Anonymous's avatar
      Anonymous
      Not applicable
      1 year ago

      Hi Jo74 ,

      We really appreciate your efforts and letting us know the update on the issue. If you let us know where exactly its going wrong we will look into it.

      Please continue using fabric community forum for your further assistance.
      Thanks and regards