Forum Discussion

saipawar's avatar
saipawar
Helper IV
5 years ago
Solved

Segment users based on time

Hi, I would like to segment users based on Delivery Time. However, when I run this condition column query, I am ending up with only "Early riser" and none of the other categories.  Is there so...
Need Help
  • mahoneypat's avatar
    mahoneypat
    5 years ago

    It is evaluating each condition separately and all your rows are likely > 5 AM so get marked as early riser.  You need to nest yours condition together.  In the Formula Bar (turn it on in Options if not visible) modify your step with 'and' in between to look like this.

     

    = Table.AddColumn(#"Changed Type", "Custom", each if [Column1] > #time(5, 0, 0) and [Column1] < #time(10, 0, 0) then "Early Riser" else if [Column1] >= #time(10, 0, 0) and [Column1] < #time(15, 0, 0) then "Lunch Person" else "Other")

     

    Pat

saipawar's avatar
saipawar
Helper IV
5 years ago

Hi Pragati11 

 

I edited the condition as you said but unfortuntely it did not work.

 

 

Pragati11's avatar
Pragati11
Super User
5 years ago

Hi saipawar ,

 

I don't see a multiple condition for you first scenario. You haven't done what I mentioned above. Also you can do it using this Conditional Column in Power Query.

You will have to create a custom column and then write a IF-ELSE loop. Also, you will have to give a proper order to your conditions.

 

If you can share sample data as a file, we can help you frane the IF-ELSE condition.

 

Thanks,

Pragati