Hi all,
I have a dataset with more than 70,000 rows with weather data. I need to convert my cardinal points (N,E,ENE, S, W, WSW, ect..) to degrees ( 0, 90, ec..), I am trying to automate this process. Is there anyway to do this by using Vlookup or lookup?
Thanks in advance for your help
Add a lookup table:
Cardinal Direction Degrees N 0 NNE 22.5 NE 45 ENE 67.5 E 90 ESE 112.5 SE 135 SSE 157.5 S 180 SSW 202.5 SW 225 WSW 247.5 W 270 WNW 292.5 NW 315 NNW 337.5
Now you can use INDEX / MATCH to return degrees, from a cardinal direction:
Formula:
Please Login or Register to view this content.
let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source
If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE
Walking the tightrope between genius and eejit...
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks