Python visual script handling dates as strings

314mp_M0th4 — Wed, 22 Mar 2023 10:42:05 GMT

Hello, I'm trying to insert a python visual I created (and works outside power BI), and insert into a power bi python visual. This is a gantt chart. When I try to run it it gives me the following error message:

Error Message:
Python script error.
TypeError: unsupported operand type(s) for -: 'str' and 'str'

During handling of the above exception, another exception occurred:

TypeError: unsupported operand type(s) for -: 'str' and 'str'

I suspect it is treating the date columns as a string. In the data model however, the dates are formatted as short dates and have the data type date. Can anyone explain what might be happening?

A piece of the code where i expect the error to be happening:

today = pd.Timestamp.today()

year_from_today = today + datetime.timedelta(days = 365)

proj_start = df["Verkefni hefst"].min()

df["start_num"] = (df["Verkefni hefst"] - proj_start).dt.days

df['end_num'] = (df["Verkefni lýkur"]-proj_start).dt.days

# days between start and current progression of each task

df['current_num'] = (df['Dagar í verkefni'] * df.Lokið)

df['days_start_to_end'] = df.end_num - df.start_num

Many thanks in advance!

Re: Python visual script handling dates as strings

314mp_M0th4 — Wed, 22 Mar 2023 11:51:11 GMT

My bad, I realized that doing data editing is not wise inside the python script. You should edit the data in the ways you need with dax calculations and then feed those into the python visual!

topic Re: Python visual script handling dates as strings in Developer

Python visual script handling dates as strings

Re: Python visual script handling dates as strings