Python Timestamp comparison error, but works in Jupyter notebook!

[yohanhwang]

Hi all,

So I have the exact same python script running on Jupyter notebook, that will not run on Power BI. I have the screens side by side. Basically I'm trying to create a new column for Fiscal Year using a function with specific date ranges so that it grabs the date from the date column and if it is within a certain range, it will spit out the appropriate fiscal year. But only Power BI do I get the error:

TypeError: '>' not supported between instances of 'str' and 'Timestamp'

Why would that be?

Thank you.

[lbendlin]

please include the code rather than screenshots. They are too small to read.