distribute values in specific date range

[junyetzotomayor]

Is it possible in PBI to distribute values in specific date range?

Lets say I have the following records (see screenshot):
Record 1
start date: january 2017
Record 2
start date: feb 2017
end date: may 2017
target: 17,600

I want to distribute that target to for those date range. So I should see 40,600 in April (23,000 + 17,600)

Thanks in advance!

[junyetzotomayor]

Hi @GilbertQ

So I manage to create a separate table based on the date values of my [Table]. Then, I created a Measure based from the syntax you mentioned.

After this I tried dragging the 'Measure' to my line chart in the values and it seems it still not adding up. 

Did I miss anything?

Again, thank you for the help 🙂