Forum Discussion
Split value equally next 12 Months
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!
Hi found the solution myself
This video solve the problem.Generate Monthly Dates between Start Date and End Date in Power BI
3 Replies
- lbendlin
Super User
Read about GENERATESERIES and the Power Query equivalent.
BTW - months have different number of days, so "equally" this is not.
- Aucesar
Helper III
Hi found the solution myself
This video solve the problem.Generate Monthly Dates between Start Date and End Date in Power BI