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 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=4
Hi 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
Hi Nathaniel_C Yes this was a date column (eg: 30/11/2021) but I seperated it out into three columns - did I need to do this ?
After I split the columns I then changed the type to Whole Number.JayTG123 I sent a link to my pbix, maybe that will be helpful.
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.
NathanielTHANK YOU !!! Nathaniel_C Its worked and thank you for taking the time to send me your test file over. 😀
Jay