23. How to do Adding a Custom Column in Power Query | Power Query Tutorial for Beginner Bangla
You can add a custom column to your data in Power Query to perform calculations or apply transformations to your data. Here's a basic tutorial on how to add a custom column in Power Query:
Open a Microsoft Excel workbook and go to the "Data" tab in the ribbon.
In the "Get & Transform Data" group, select "From Other Sources" and choose a data source.
Follow the prompts to connect to the data source and import the data into Excel.
The imported data will be displayed in the "Power Query Editor", where you can transform, filter, and clean the data as needed.
To add a custom column, go to the "Add Column" tab in the Power Query Editor and select "Custom Column".
In the "Add Custom Column" dialog, specify a name for the new column and enter a formula in the "Custom Column Formula" box.
You can use a variety of functions in your formula, such as SUM, AVERAGE, IF, or other built-in functions. You can also reference other columns in your formula.
Click "OK" to apply the formula and create the custom column.
The custom column will be added to the data, and the results of the formula will be displayed in the new column.
You can save the data or load it directly into a worksheet by clicking the "Close & Load" button in the "Home" tab in the Power Query Editor.
This is a basic tutorial on how to add a custom column in Power Query. By using custom columns, you can perform complex calculations and transformations on your data, making it easier to analyze and visualize your data.
COMMUNICATE WITH HASAN ACADEMY
[email protected]
#HasanAcademy #Power_Query #Power_Query_Bangla
Facebook page
/ hasanacademybanglatutorial
Subscribe link : / @hasanacademy779
Facebook group link : / 282270382269650
Facebook page link : / hasanacademybanglatutorial
Most popular video Link :
• Excel VBA Bangla Tutorial 48 : Data Entry ... • Excel VBA Bangla Tutorial 50 : Create Add ... • Excel tutorial Bangla 24 : Top 10 Used For... • Excel VBA Bangla Tutorial 54: Add- Employe... • Introduction to Pivot Tables-Charts-and-Da... • Excel VBA Bangla Tutorial 49 : Invoice | B...
Most of the people is think about that how I will learn .But they didn't get any idea & trustworthy source. Don't hesitated Hasan Academy with you. You will learn from here, Excel, Excel Chart, Pivot Table, Vlookup, Formula function