Forum Discussion
Solved
Create Multiple Calculated Columns in Transform or DAX at once
Hello, I am trying to do a loop in Power BI since I have a dataset with multiple categories. Each category has it's own set of columns. In this example, there are categories A, B, and C, and each ...
Sounds more like a data format issue than anything else, you can get it into a form that is much easier to calculate on by following these steps in Power Query
Step 1: Unpivot
Step 2 Split the Attribute
Step 3: Repivot by Attribute.1
Step 4: add your division column
yeah it might have been faster to do it manuall lol, hope this helped
Sounds more like a data format issue than anything else, you can get it into a form that is much easier to calculate on by following these steps in Power Query
Step 1: Unpivot
Step 2 Split the Attribute
Step 3: Repivot by Attribute.1
Step 4: add your division column
yeah it might have been faster to do it manuall lol, hope this helped