Hi DNA Team, Quite recently I thought about one idea if this is possible to do it in Power Query. I tried to find something on youtube or google but couldn’t find anything relevant. I was just wondering as per the attached file is it possible to create something similar in Power Query. Prepaymen…

Hi @Matty , Here’s another approach. First calculate the number of months between the dates [image] Created a list that contains a value for each month [image] Extracted that list to new rows and calculated a monthly charge date [image] You should not be aiming to do DAX calculations acros…