Forum Discussion

jppuam's avatar
jppuam
Helper V
1 year ago
Solved

Differing values

Hello, i want to differing values that 1 have in a period, for the next 12 months ahead. for example: Insurance code Begging date end data value (costs) person A 31/12/2024 31/12/2024 ...
Need Help
  • ahmedoye's avatar
    ahmedoye
    1 year ago

    You can try in Power Query with the following steps:

     

    1. Add a new Column in PowerQuery using this formular pattern: List.Numbers(0, ([Data value]/12)+1)



    2. Expand this new column using the "Expand to new rows" option. Change the data type here to Whole Number
    3. You can create a new Date End Column using this formula pattern: Date.AddMonths([Dateend], [NewCol])

    4. If this works for you, kindly mark as Answer to make it easier for anyone with similar issues to find a solution
ahmedoye's avatar
ahmedoye
Responsive Resident
1 year ago

You can try in Power Query with the following steps:

 

  1. Add a new Column in PowerQuery using this formular pattern: List.Numbers(0, ([Data value]/12)+1)



  2. Expand this new column using the "Expand to new rows" option. Change the data type here to Whole Number
  3. You can create a new Date End Column using this formula pattern: Date.AddMonths([Dateend], [NewCol])

  4. If this works for you, kindly mark as Answer to make it easier for anyone with similar issues to find a solution