Forum Discussion

JayTG123's avatar
JayTG123
Advocate 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
Advocate I
4 years ago

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. 

Nathaniel_C's avatar
Nathaniel_C
Community Champion
4 years ago

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

  • JayTG123's avatar
    JayTG123
    Advocate 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
      Community 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!