Forum Discussion

Luisje23's avatar
Luisje23
New Member
2 years ago
Solved

Need help regarding a date column PowerBi

Hi, currently I have a date column that is all the dates in 2022 year. I want the dates to switch to the 2023 year from row 49 onwards.

 

I have attached a picture of the column and column name that I want to change. The dates are correct up until row 49 which need to start going 01/01/2023 instead of repeating and still showing 01/01/2022

 

Thanks

 

 

 

 

Need Help
  • ryan_mayu's avatar
    ryan_mayu
    2 years ago

    Luisje23 

    you can ceate an index column in pq

     

     

     

    then create a column

    Column = if('Table (2)'[INDEX]<=49,'Table (2)'[DATE],EDATE('Table (2)'[DATE],12))

1 Reply

  • ryan_mayu's avatar
    ryan_mayu
    Super User
    2 years ago

    Luisje23 

    you can ceate an index column in pq

     

     

     

    then create a column

    Column = if('Table (2)'[INDEX]<=49,'Table (2)'[DATE],EDATE('Table (2)'[DATE],12))