Forum Discussion
distribute values in specific date range
And have you made a relationship between your main table and the Date table?
I reckon if we add a cumulative measure we will be getting close. It should look something like this, and then add it to your visual
My Measure = CALCULATE (
SUM ( 'Table'[target] ),
FILTER (
ALL ( 'Date'[Date] ),
'Date'[Date] <= MAX ( 'Table'[Date] )
)
)Oh junyetzotomayor, if that doesn't work, can you please share a sample of your data table (including the name of the table) so we can give you a more precise formula.
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)
Do you have a relationship between NPS and your DATE table?
