Forum Discussion

New Member

8 years ago

Solved

Divide values within column to create new column

Hi, I'm quite new to Power BI. I need help with a piece of logic I used to implement in QlikView. It is a memory-intensive operation, and we were thinking of executing this piece in Power BI. Our...

v-yulgu-msft
8 years ago
Hi saurabhkul,

Suppose the source table is named as 'Test4'. Please refer to below steps that are all applied in Query Editor mode.

1. Duplicate table 'Test4'

2. Pivot the duplicated table.

3. Merge the source table with the duplicated one.

4. Expand columns without selecting 'Series_ID'. Then, unpivot them.

5. Right click the 'Attribute' column, choose "Replace values" option.

6. Add a custom column.

7. Remove 'Value' field.

8. Pivot column.

9. Final output.

Best regards,

Yuliana Gu

Icon for Microsoft Employee rank

Microsoft Employee

8 years ago

Suppose the source table is named as 'Test4'. Please refer to below steps that are all applied in Query Editor mode.

1. Duplicate table 'Test4'

2. Pivot the duplicated table.

3. Merge the source table with the duplicated one.

4. Expand columns without selecting 'Series_ID'. Then, unpivot them.

5. Right click the 'Attribute' column, choose "Replace values" option.

6. Add a custom column.

7. Remove 'Value' field.

8. Pivot column.

9. Final output.

Best regards,

Yuliana Gu

New Member

8 years ago

Hi Yuliana,

Thanks a lot for the detailed explanantion. However, step 3 (merging) wasn't successful for me. I'll really appreciate your help on this.

Note: The CSV file is 56 MB. Did pivoting such a big table possibly create an issue? Also, I've hidden the Series_ID values due to data sensitivity.

Thanks,

Saurabh