Forum Discussion
Create new column for Fiscal Year
Hi JayTG123 ,
Go to Power Query, select Conditional Column, insert the code:if [Offense date.2] >= 4 then Text.Combine({Text.From([Offense date.3]),Text.From([Offense date.3]+1-2000)},"/") else Text.Combine({Text.From([Offense date.3]-1),Text.From([Offense date.3]-2000)},"/")
Pics to follow.
Let me know if you have any questions.
If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos 👍are nice too.
Nathaniel
Hi JayTG123 ,
Go to Power Query, select Conditional Column, insert the code:
if [Offense date.2] >= 4 then Text.Combine({Text.From([Offense date.3]),Text.From([Offense date.3]+1-2000)},"/") else Text.Combine({Text.From([Offense date.3]-1),Text.From([Offense date.3]-2000)},"/")
Pics to follow.
Let me know if you have any questions.
If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos 👍are nice too.
Nathaniel
Hi JayTG123 Here are the steps:
Go to Power QuerySelect Add Column
Select Custom Column
Add a title for the column
Paste the code into the box click ok
Change the column type to Text
Let me know if you have any questions.
If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos 👍are nice too.
NathanielHi Nathaniel_C thank you so much for responding!! I have done exactly as you said but I am now getting an error message in the new column.. please see below:
Expression.Error: We cannot apply operator >= to types Record and Number.
Details:
Operator=>=
Left=
Offence date.2=10
Right=4Hi JayTG123 as it looks like you split out the date into these three columns, I assumed that they are whole numbers, am I correct?
Thank you,
Nathaniel
