Forum Discussion

junyetzotomayor's avatar
junyetzotomayor
Helper I
9 years ago

Distribute values in specific date range

Hi all,

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
end date: june 2017
target: 23,000

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!Hi all,

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
end date: june 2017
target: 23,000

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!

1 Reply

  • v-yulgu-msft's avatar
    v-yulgu-msft
    Microsoft Employee
    9 years ago

    Hi junyetzotomayor,

     

    According to current description, it's hard to reproduce your scenario.

     

    Please share more sample data so that I can test. And please elaborate why it should display 40,600 in April (23,000 + 17,600). Then, what is the correct result in March, in May, in June, in July, etc. Please tell us what is your expected output, which visualizaion you use to display the distributed values.

     

    Best regards,
    Yuliana Gu