Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

CREATE COLUMN

HELLO

How do I create a column from the smallest member and repeat it in a column in PowerQuery that does not go out of direct query mode?

Need Help
  • v-jingzhang's avatar
    v-jingzhang
    4 years ago

    Hi Anonymous 

     

    Create a calculated column with MIN. Although there is no Data view for DirectQuery table, you can see data when you put columns into a visual. 

    New Column = MIN('TableName'[ColumnName])

     

    Regards,

    Jing

    If this post helps, please Accept it as Solution to help other members find it.

3 Replies

  • v-jingzhang's avatar
    v-jingzhang
    Community Support
    4 years ago

    Hi Anonymous 

     

    Since it is in Direct Query mode, creating a calculated column or measure to get the same result is a better choice. This will not go out of direct query mode. 

     

    Could you share some sample data and desired result so that we can help create an expression? Do you want to populate a new column with the smallest value in another column?

     

    Best Regards,
    Community Support Team _ Jing

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      thank you 

      hello

      yes ,I want smallest value another column

      • v-jingzhang's avatar
        v-jingzhang
        Community Support
        4 years ago

        Hi Anonymous 

         

        Create a calculated column with MIN. Although there is no Data view for DirectQuery table, you can see data when you put columns into a visual. 

        New Column = MIN('TableName'[ColumnName])

         

        Regards,

        Jing

        If this post helps, please Accept it as Solution to help other members find it.