Forum Discussion
Solved
Creating a line graph
Good afternoon, Thanks for your help on my last question. I now have another that has probably already been asked and answered but I can't seem to find it. I have a single row of data I am trying ...
in pq you can create a new column
= if [2025] = "January" then 1
else if [2025] = "February" then 2
else if [2025] = "March" then 3
else if [2025] = "April" then 4
else if [2025] = "May" then 5
else if [2025] = "June" then 6
else if [2025] = "July" then 7
else if [2025] = "August" then 8
else if [2025] = "September" then 9
else if [2025] = "October" then 10
else if [2025] = "November" then 11
else if [2025] = "December" then 12
else nullthen make sure the new column's data type is whole number and sort 2025 by the new column
at last sort by the 2025 column
pls see the attachment below
Wait! I think I'm close. I just need to figure out how to get the months in the correct order. They are listed in order on the uploaded data.