Need help for date type conversion in python script to manipulate data?

[Suvechha]

Hi All,
I need help in python script -

1. Date Start , Date End convert to Text instead of Date - please help.
   Though the Date Start and Date End is formating correctly in python code
   
   

But when using the same code in power bi - giving me issue

I am adding the python script which I use to import data , please find the path : python/vs_code.py at main · suvechha/python · GitHub

[c-rob (Chuck R.)]

I also use Power BI with Postgresql and MS SQL and I work with dates. I have questions.

1. Why are you using Python when PBI can do all of what you do, like data conversion? (I realize you may know Python better than PBI, and Python gives us more flexibility. So that’s a good reason to use Python.)
2. Are you only data sources the Excel spreadsheet I see in your code?
3. Are your date columns linked from another spreadsheet or do they physically exist in the spreadsheet? To simplify things make sure the dates physically exist in your Excel spreadsheet, and are not linked to there. PBI has limitations and a few bugs. “Keep It Simple”.

[Suvechha]

Hi @c-rob ,

Thanks for your reply.
I am trying to build a logic where Timesheet Date in DSR table needs to compare with Date Start and Date End.

Thus trying to use Python for data manipulation.

I have a PBI question in the below link

Creating Measures without common relationship??

and also in Python

How to get the logic to be included in Python sample code

have got two df1 and df2 which has a field key contains multiple rows. If the key match in both data frames then I need to calculate the field Qualified. Qualified = CASE WHEN Timesheet Date >=Date Start && Timesheet Date <= Date End Comments contains "L" then "Learner" WHEN Timesheet Date >= Date Start && Timesheet Date <= Date Expiry then "Qualified" WHEN Timesheet Date >=Date End && Date Expiry = null then "Not Qualified" WHEN Timesheet Date < Date Start then "Learner" I…

Will you able to have a look and help please

[c-rob (Chuck R.)]

Just off the top of my head. If you have 2 tables, call them table1 and table2, in PBI that don’t have linking fields (like some type of ID field) you can link them with a date table in PBI. But this requires both tables, table1 and table2, each have a date field that links to the date field in your date table.

Have you read up and tried a date table? Here’s a search for you.

We do this for time sheets as well because the part of our system that does time sheets was hacked together (by the vendor) and wasn’t designed very well.