Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Power Query Add New Column > Date.ToText as MM/YYYY

Hi I am trying to create a new column in power query, so that I can create an effective relationship between our opporunities and sales targets, by owner and mm/yyyy   Currently our Close Dates are...
Need Help
  • amitchandak's avatar
    amitchandak
    4 years ago

    Anonymous , Based on what I got, you need

    Date.ToText([Date],"MM/yyyy")

     

    Please keep the case same

amitchandak's avatar
amitchandak
Super User
4 years ago

Anonymous , Based on what I got, you need

Date.ToText([Date],"MM/yyyy")

 

Please keep the case same