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.

v-jingzhang's avatar
v-jingzhang
Icon for Community Support rankCommunity 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
    Icon for Community Support rankCommunity 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.