Forum Discussion
SachinC
7 years agoHelper V
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 les...
v-jiascu-msft
7 years agoMicrosoft Employee
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,