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.
Hi everyone
Can anyone help with how to convert wind degrees to direction. For example, I have the degrees like below but want the column on the right. Thanks in advance!
Deg | Dir |
202 | SSW |
208 | SSW |
229 | SW |
249 | WSW |
276 | W |
311 | NW |
335 | NNW |
345 | NNW |
24 | NNE |
24 | NNE |
29 | NNE |
34 | NE |
26 | NNE |
22 | NNE |
17 | NNE |
Solved! Go to Solution.
Hi @Anonymous
You don't describe the ranges for each Dir. I've just used 4 Dirs as an example to show the pattern you can use. You would just have to update/expand the conditions to what you need.
NewColumn = VAR _Deg = Table1[Deg] RETURN SWITCH(TRUE(), (_Deg >= 0 && _Deg< 90), "N", (_Deg >= 90 && _Deg< 180), "E", (_Deg >= 180 && _Deg< 270), "S", (_Deg >= 270 && _Deg< 360), "W" )
Hi @Anonymous
You don't describe the ranges for each Dir. I've just used 4 Dirs as an example to show the pattern you can use. You would just have to update/expand the conditions to what you need.
NewColumn = VAR _Deg = Table1[Deg] RETURN SWITCH(TRUE(), (_Deg >= 0 && _Deg< 90), "N", (_Deg >= 90 && _Deg< 180), "E", (_Deg >= 180 && _Deg< 270), "S", (_Deg >= 270 && _Deg< 360), "W" )
could you tell me, what is this programme? to insert in this code
Thanks AIB. I don't fully understand how to implement your solution. I'm sure it works but it got me thinking of a way I could do it through the query editor
#"Added Conditional Column" = Table.AddColumn(#"PREVIOUS STEP", "dir", each if [deg] >= 348.75 then "N" else if [deg] > 326.25 then "NNW" else if [deg] > 303.75 then "NW" else if [deg] > 281.25 then "WNW" else if [deg] > 258.75 then "W" else if [deg] > 236.25 then "WSW" else if [deg] > 213.75 then "SW" else if [deg] > 191.25 then "SSW" else if [deg] > 168.75 then "S" else if [deg] > 146.25 then "SSE" else if [deg] > 123.75 then "SE" else if [deg] > 101.25 then "ESE" else if [deg] > 78.75 then "E" else if [deg] > 56.25 then "ENE" else if [deg] > 33.75 then "NE" else if [deg] > 11.25 then "NNE" else if [deg] >= 0 then "N" else null ),
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 |
---|---|
110 | |
94 | |
80 | |
67 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |