Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I'm trying to create new colums for Carry Metres and Kick Metres based on a data set that looks like below. I need to copy the Carry Metres into a seperate column and the same with the Kick Metres and dont know how to do it, any help would be greatly appreciated.
Action | Metres | Carry Metres | Kick Metres |
Carry | 5 | ||
Carry | 15 | ||
Kick | 28 | ||
Carry | 3 | ||
Kick | 34 | ||
Kick | 21 | ||
Carry | 34 |
Solved! Go to Solution.
Hi , @jamieham
Try to create calculated column as below:
Carry_Metres = IF(Table_basic[Action]="Carry",Table_basic[Metres],BLANK())
Kick_Metres = IF(Table_basic[Action]="Kick",Table_basic[Metres],BLANK())
For more details,please refer to the sample file.
Best Regards,
Community Support Team _ Eason
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi , @jamieham
By the way ,if you use the function "pivot column" in "Transform Data", it is suggest to create a index column first .
Best Regards,
Community Support Team _ Eason
@jamieham , pivot - This should work in your case
https://radacad.com/pivot-and-unpivot-with-power-bi
Group data
https://www.poweredsolutions.co/2019/07/30/grouping-rows-with-power-bi-power-query/
Hi @jamieham
I would go to Power Query editor
Select these two columns
On the transform menu --> Pivot(Hope you have other columns in this table otherwise it will error out)
Hope it resolves your issue? Did I answer your question? Mark my post as a solution! Appreciate your Kudos, Press the thumbs up button!! Linkedin Profile |
Hi @jamieham
Not very clear. What is your end goal?
How about creating a duplicate column for both.
Otherwise
carry meter new = [carry meter]
Kick meter new = [Kick meter]
Hope it resolves your issue? Did I answer your question? Mark my post as a solution! Appreciate your Kudos, Press the thumbs up button!! Linkedin Profile |
I need to be able to seperate the kick metres and carry metres into different columns. At the moment kick and carry metres are both in the same column
Hi , @jamieham
Try to create calculated column as below:
Carry_Metres = IF(Table_basic[Action]="Carry",Table_basic[Metres],BLANK())
Kick_Metres = IF(Table_basic[Action]="Kick",Table_basic[Metres],BLANK())
For more details,please refer to the sample file.
Best Regards,
Community Support Team _ Eason
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |