Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
Hi all,
I have the following data in Power Bi - I have seperated the three columns up individually however I wish to create a new year column that will display the year like 2021/22 (UK Financial Year) The year starts from April - March. I have tried other methords I found on these forums but I am unable to replicate the year followed by the forward slash / and then then the 22 afterwards.
Solved! Go to Solution.
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
Proud to be a Super User!
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
Proud to be a Super User!
Hi @JayTG123 Here are the steps:
Go to Power Query
Select 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.
Nathaniel
Proud to be a Super User!
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
Proud to be a Super User!
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.
Nathaniel
Proud to be a Super User!
THANK YOU !!! @Nathaniel_C Its worked and thank you for taking the time to send me your test file over. 😀
Jay
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
94 | |
87 | |
84 | |
73 | |
49 |
User | Count |
---|---|
143 | |
131 | |
110 | |
64 | |
55 |