Forum Discussion
Best Practices for data conversion
Hi,
Starting out with PowerBi. I've got an XML file with tracking information of a flight.
Two issues that I'm facing:
- There's this column "AvPlanTrackLog" that has "speed.../speed" in it and I'm not sure how to access this data. I got to it by "splitting" the column a few times into new columns. However, that doesn't feel right.
- Once I went with the multiple splitting approach I had the "speed" data as decimal numbers, however, this is m/s and I need kph. How do I go about multiplying the column by 3.6?
Cheers,
David
What I understood from your post is that How to multiple speed column with 3.6 in order to render it into kph term. Right?
So for this you need to add a new column like below:
Speed in KPH = [SpeedColumn]*3.6
Don't forget to hit THUMBS UP and mark it as a solution if it helps you!
3 Replies
What I understood from your post is that How to multiple speed column with 3.6 in order to render it into kph term. Right?
So for this you need to add a new column like below:
Speed in KPH = [SpeedColumn]*3.6
Don't forget to hit THUMBS UP and mark it as a solution if it helps you!
Hi david_obrien ,
I think you have already got the data you want. According to your requirement, you need to ensure that your new data is numeric but not text.
Then create a new column.
New Column = 'Table'[Speed]*3.6If you want to add "kph" as a unit, you could add the following DAX:
New Column = 'Table'[Speed]*3.6&"kph"Thank you for accepting my post as a Solution!
I will really appreciate your KUDOS/THUMBS UP for support.😊
