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 . The issue is likely due to grouping of your conditional statements.

Try this

 

if 
    [apptcancelreason] = "BLANK" and 
    (
        [apptslotstatus] = "2 - Checked In" or 
        [apptslotstatus] = "3- Checked Out" or 
        [apptslotstatus] = "4 - Charge Entered"
    ) and 
    [apptdate] < DateTime.LocalNow() 
then 
    "Appointment Completed"

 

 With these modifications, appointments with a status of "2 - Checked In" should now be correctly marked as "Appointment Completed" instead of "No Show", as long as the other conditions are met. The rest of the logic remains the same. 

 

Let me know if you have any more questions.

 

Thank you,

Abhinav

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

    Thanks for the feedback. Unfortunately, that changed all of them to "No Show" instead of "Appointment Completed"

    • mussaenda's avatar
      mussaenda
      Icon for Community Champion rankCommunity Champion
      2 years ago

      Hi mgaut341 ,

       

      AbhinavJoshi is right with the condition grouping. 

      One more thing we need to check are the values we are declaring in conditions.

      is "BLANK" really a BLANK word in all caps? (Note that Power Query is case sensitive)

      Or is it null as in a null value? Because if it is null then we need to do = null instead of = "BLANK".

       

      Hope this helps  

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

        I've tried changing it to "null" but the same issue arises. 2-Checked In still shows up as No Show, while 3 & 4 show up at Appointment Completed