Date field change to text - when merge two tables using python code fro transform purpose ?

[ashmitp869]

Hi All,

Need suggestion in data manipilation using python. I need to identify the Employee is qualified for training or not in DSR_DNQ table depending on certain condition from Qualification table.

So I merge two tables with python to transform and shape the data but the datefields are all text.

How to change the format ?

[amitchandak]

@ashmitp869 , I do not see any dates in the Start and end dates. Seem like format issue. If that not working bring them as text and format them in Power Query

[ashmitp869]

Hi  ,I can't do this in power query as my ultimate goal is to merge two dataset and put this condition which depends on two table.

1. 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 had raise this before but didn't got any reply.

   https://community.fabric.microsoft.com/t5/Desktop/Help-me-to-build-a-measures-from-two-different-tab...

@amitchandak