Conditional Column Advice Needed - 2 Questions

SachinC · ‎03-11-2019

Hi,

Q1: Can you review this conditional column query to ensure its correct:-

If [Mileage] is less than 25 Then 0-25 Miles

If [Mileage] is less than 100 Then 25-100 Miles

If [Mileage] is less than 200 Then 100-200 Miles

If [Mileage] is greater than 201 Then 200 Plus

Is this the correct If...Then... stack? If not, then please correct me.

Q2: Import Mode

When I add a Conditional Column; it converts my PowerBi report to Import Mode as opposed to Direct Query. Why is this? What is the advantage and disadvantage of this please?

Thanks.

v-jiascu-msft · ‎03-12-2019

Hi @SachinC ,

A1: If you add it from the UI of the conditional column, usually it would be correct. You also can check the code by opening the Advanced Editor. Please refer to the snapshot below.

A2: It's still Direct Query mode in my test. How did you add the new column? Maybe it's too complicated.

Best Regards,

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.