Split value equally next 12 Months

[Aucesar]

Hi Community,

Need help to acomplish this task, I could not find the desire result using the examples from here (Using cross join).

I need the BI_LancContab[nVlrLanc] to be splitted for the next 12 months based on BI_LancContabil [dDatLanc] which

It´s not dificult to find the 12months value BI_LancContab[Division] and the End Date BI_LancContab[EndDate]

Link to the pbix file - sampledate5.pbix




Question is how to split the value in the period?

Thanks in Advance!

[Aucesar · Accepted solution]

Hi found the solution myself

This video solve the problem.

Generate Monthly Dates between Start Date and End Date in Power BI

[lbendlin]

Read about GENERATESERIES and the Power Query equivalent.

BTW - months have different number of days, so "equally"  this is not.

[Aucesar]

Hi @lbendlin Will try generateseries, I need to split yearly payment in to months, so equaly by 12 times. Thanks for the reply.