Forum Discussion

JayTG123's avatar
JayTG123
Icon for Advocate I rankAdvocate I
4 years ago
Solved

Create new column for Fiscal Year

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 Financia...
Need Help
  • Nathaniel_C's avatar
    Nathaniel_C
    4 years ago

    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

JayTG123's avatar
JayTG123
Icon for Advocate I rankAdvocate I
4 years ago

THANK YOU !!! Nathaniel_C  Its worked and thank you for taking the time to send me your test file over. 😀

 

Jay

Nathaniel_C's avatar
Nathaniel_C
Icon for Community Champion rankCommunity Champion
4 years ago

Hi JayTG123, you are most welcome!  If you had kept it as a date column, you could have done something like Date.Year() to get the year from the date. Let me recommend "Master Your Data" by KenPuls and Miguel Escobar!