Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Power BI - updated colums automatically

say I have Get Data from CSV, and loaded into the Power BI. say next time, I need to add in a few more columns, do I need to remove that table and redo everything again? Can I if Refresh data, it w...
Need Help
Show and Tell
  • dhruvinushah's avatar
    dhruvinushah
    4 years ago

    Hi Anonymous ,

     

    There are several ways you can add columns to your already loaded query. 

    Via Power Query using 'M'  -  you can use the Custom Column and build your custom column.

    Via Power BI Desktop using DAX - you can create a calculated column. 

     

    Based on your requirement and level of familiarity with either languages you can add columns accordingly. DAX is generally more familiar to excel users, while M is more familiar with C # users. 

     

    Hope this helps, please give thumbs up and Mark my answers as solution for your question. Thanks!

Anonymous's avatar
Anonymous
Not applicable
4 years ago

I know there is Add Column in Power Query Editor, but what if I want to add in new column which is just another new column that is not related to another other columns?

  • dhruvinushah's avatar
    dhruvinushah
    Responsive Resident
    4 years ago

    Hi Anonymous ,

     

    There are several ways you can add columns to your already loaded query. 

    Via Power Query using 'M'  -  you can use the Custom Column and build your custom column.

    Via Power BI Desktop using DAX - you can create a calculated column. 

     

    Based on your requirement and level of familiarity with either languages you can add columns accordingly. DAX is generally more familiar to excel users, while M is more familiar with C # users. 

     

    Hope this helps, please give thumbs up and Mark my answers as solution for your question. Thanks!