Forum Discussion

SachinC's avatar
SachinC
Helper V
7 years ago

Conditional Column Advice Needed - 2 Questions

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.

Need Help
Show and Tell
Tips and Tricks

1 Reply

  • v-jiascu-msft's avatar
    v-jiascu-msft
    Microsoft Employee
    7 years ago

    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. 

    Conditional-Column-Advice-Needed-2-Questions

     

    Best Regards,