Forum Discussion

Helper I

9 years ago

distribute values in specific date range

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 en...

junyetzotomayor

Helper I

9 years ago

Hi Phil_Seamark

Thanks for the reply.

I followed your steps but for some reason it still didnt work :(

Please see screenshot of my sample data table.

Main Table: NPS and Sales Target Capture

-2 tables are appended (NPS and Sales Target Capture)

- Im only interested to calculate the cumulative TEU of Sales Target Capture as they are the ones with 'Start Date' and 'End Date' as seen on screenshot below.

Date Table: Created a CALENDAR() based from the min and max values of Sales Target Captur (see screenshot)