Forum Discussion

mgaut341's avatar
mgaut341
Icon for Helper II rankHelper II
2 years ago

Custom Column

I created a custom column in my power query that looks at appointment slot status. When I run my code, the slot status for "2- Checked In", is being marked as "No Show" instead of "Appointment Comple...
Need Help
AbhinavJoshi's avatar
AbhinavJoshi
Icon for Responsive Resident rankResponsive Resident
2 years ago

Hi mgaut341 . Can you please provide a sample data where it is coming as "No Show". It would help us in identifying the problem.

  • mgaut341's avatar
    mgaut341
    Icon for Helper II rankHelper II
    2 years ago

     

    • mussaenda's avatar
      mussaenda
      Icon for Community Champion rankCommunity Champion
      1 year ago

      We need the data that we can copy and where all the columns are present
      [apptdate], [apptslotstatus], [apptcancelreason]

       

      I am thinking if [apptdate] is the culprit for this since the value for this field will not be exactly the same as DateTime.LocalNow(). It is just my assumption since I cannot see the data for the field.

       

      Hope this helps