Forum Discussion

Aucesar's avatar
Aucesar
Icon for Helper III rankHelper III
2 years ago
Solved

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!

3 Replies