Following Are The Steps For Extracting Age Into Different Columns

1. Load your data:

   • Import your dataset into Power BI.

2. Open Power Query Editor:

   • Go to the "Home" tab and click on "Transform Data" to open the Power Query Editor.

3. Select Columns:

   • In the Power Query Editor, select the two columns you want to use for the percentage calculation.

4. Add Custom Column:

   • Go to the "Add Column" tab.

   • Click on "Standard" and then select "Divide".

   • This will create a new column with the result of dividing the first selected column by the second selected column.

5. Convert to Percentage:

   • Select the new column created from the division.

   • Go to the "Transform" tab.

   • Click on "Standard" and then select "Percentage".

   • This will format the result as a percentage.

6. Rename the New Column:

   • You can rename the new column to something more meaningful by right-clicking on the column header and selecting "Rename".

7. Close and Apply:

   • Once you have added the new column and formatted it as a percentage, click on "Close & Apply" to apply the changes and return to the main Power BI window.

You should now have a new column with the percentage calculated from the two selected columns in your dataset.

1. Load your data:

   • Import your dataset into Power BI.

2. Open Power Query Editor:

   • Go to the "Home" tab and click on "Transform Data" to open the Power Query Editor.

3. Select Columns:

   • In the Power Query Editor, select the two columns you want to use for the percentage calculation.

4. Add Custom Column:

   • Go to the "Add Column" tab.

   • Click on "Standard" and then select "Percent Of".

   • This will create a new column with the result of calculating the percentage of the first selected column relative to the second selected column.

5. Rename the New Column:

   • You can rename the new column to something more meaningful by right-clicking on the column header and selecting "Rename".

6. Close and Apply:

   • Once you have added the new column and formatted it as a percentage, click on "Close & Apply" to apply the changes and return to the main Power BI window.

You should now have a new column with the "percent of" calculation in your dataset. 

1. Load your data:

   • Import your dataset into Power BI.

2. Open Power Query Editor:

   • Go to the "Home" tab and click on "Transform Data" to open the Power Query Editor.

3. Select Columns:

   • In the Power Query Editor, select the two columns you want to use for the modulo calculation.

4. Add Custom Column:

   • Go to the "Add Column" tab.

   • Click on "Standard" and then select "Modulo".

   • This will create a new column with the result of the modulo operation between the two selected columns.

5. Rename the New Column:

   • You can rename the new column to something more meaningful by right-clicking on the column header and selecting "Rename".

6. Close and Apply:

   • Once you have added the new column with the modulo calculation, click on "Close & Apply" to apply the changes and return to the main Power BI window.

You should now have a new column with the modulo calculation in your dataset.