Forum Discussion

svishwanathan's avatar
svishwanathan
Icon for Helper III rankHelper III
8 years ago
Solved

Power Query Syntax

Hello   I am trying to write some queries in M and have not found much success.   I have a column with years ranging from 1985 to 2026. I want to find the min year and also the relative year (whi...
Need Help
  • MarcelBeug's avatar
    MarcelBeug
    8 years ago

    Sure:

     

svishwanathan's avatar
svishwanathan
Icon for Helper III rankHelper III
8 years ago

Thanks Marcel

 

I will try this but I was wondering that instead of getting the Advanced Editor and tweaking hte code, can i write it as custom column

 

when I edit my query..

 

Please let me know if I am not using the correct language and using M incorrectly here

 


Swati

MarcelBeug's avatar
MarcelBeug
Icon for Community Champion rankCommunity Champion
8 years ago

Sure:

 

  • svishwanathan's avatar
    svishwanathan
    Icon for Helper III rankHelper III
    8 years ago

    Thanks 

     

    I wouldnt go very far without help from you and others

     

    Btw I saw one of your videos even today on  Youtube


    Thanks to you and all others who are so patiently leading us along