Hi all, I have a tough one at hand… The Bills export I get from our system does not generate the recurring ones, it just provides a info column with the Frequency type. When an expense is recurring, i.e. every other month from the Transaction Date (lets suppose Oct 3rd 2021), I need to generate (…

Hi @Thimios , :thinking: I can recommend a PQ course if you want to get up to speed, you’ll find it in the portal… I did some prepping. First created this supporting query (Important! know that PQ is case sensitive so these Freq names need to match with the Freq names in your ScheduledBIlls table). …

Generate recurring expenses

Power Query

Melissa August 18, 2021, 3:26pm 2

Hi @Thimios,

I’m away now, but will have a look at your sample when I get back. In the meantime you can examine this topic, that seems similar.

I hope this is helpful

1 Like