Forum Discussion

adamabdell's avatar
adamabdell
New Member
4 years ago
Solved

Changing Data Type after Python Script

Before I write my python script the 'Period' Column is of type Text but after I apply my script 'Period' becomes of type Date How to I get it to stop automatically changing the data type? I want to ...
Need Help
  • v-yalanwu-msft's avatar
    v-yalanwu-msft
    4 years ago

    Hi, adamabdell ;

    You could delete it in power query.

    First open Formula Bar,

    Then delete the date's type.


    Best Regards,
    Community Support Team _ Yalan Wu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

mh2587's avatar
mh2587
Super User
4 years ago

Change it by clicking the calendar icon then select the text type 

  • adamabdell's avatar
    adamabdell
    New Member
    4 years ago

    mh2587  thank you for your response!

    I have done that. But the issue is that the script is then not recognizing the change. 

    My table has 2 columns. Period and Value.

    My script basically says:

    if Period = 'a period':

           then Value - 100 

    else:

           then Value - 50

     

    And with using pandas in the the return values are being stored in a new column

    Does that make sense?