Forum Discussion

xile015's avatar
xile015
New Member
8 years ago
Solved

using a calculated column for conditional column

i have an excel file with 5 columns: name, quiz1, quiz2, quiz3, and quiz4 the name column has the names of the students (unique) and each of the quiz columns have their scores for each quiz afte...
Need Help
  • v-jiascu-msft's avatar
    v-jiascu-msft
    8 years ago

    Hi xile015,

     

    There isn't a problem in this scenario. The column created in the Data view won't appear in the Query Editor. You can create a Conditional column in the Query Editor instead.

    using_a_calculated_column_for_conditional_column

     

    Best Regards,

    Dale

sraj's avatar
sraj
Responsive Resident
4 years ago

Just as mentioned above I tried to create a column in the custom column, changed the type to DATE STILL SEE error

= Table.AddColumn(#"Changed Type", "7th", each [Merged] + 7)