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.

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.