Power Query (M language) : How to calculate Madurity of Invoices

[Gustavo140494]

Hi Guys,

I'm trying to create a forecast of the amount of cash that we will need to follow up within the month in the company , for this reason i need to include not only the amounts that are due at the moment the report is released but also include the amounts that are Due during the current month, we need a separate column with the amount that is getting due only in the month and the past due.

For this task I create two columns one with the Start of the Month and the other with the End of Month, to set a Treshold beetween dates and obtain the amounts due during that period based on their due date, however, This is showing me all the Past Due not only the amounts that get due on the Month, can some of you let me know what i need to fix in the conditional formula.

I hope I explain correcly what im seehing from this and some of you can share the knowlegde and help me to complete a task below is the spreadsheet and the code is attached as well :

.https://1drv.ms/x/s!AgtJ-TOjZmftsUx4Ntq6Mo5_gbRk?e=cwDwxA

[v-frfei-msft]

Hi @Gustavo140494 ,

Sorry, I cannot get you. Could you please share the exepcted result to me as well?

[Gustavo140494]

Hi Frank, 

Im trying to get into the due in the month column the amounts that get due on current month only, see below the  example the $59,750 are getting current they are not due yet they get due on 11/12/2019 the end of current month is 10/31/2019 so in this particular case the column "Due in the month" must show 0 but is showing the total balance even this not due with in the month.

i hope i explain the result im seeking.