Forum Discussion
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...
Hi Phil_Seamark
Awesome it worked! Thank you!
However, the only catch is, we can only set one relationship (active) for between two tables. For Start Date and End Date, the only active one is the 'Start Date' hence when I filter my date range, other filters in my report is not working properly. Do you have any thoughts on this?
Example:
Start Dates:
Jan. 31, 2017
Feb. 4, 2017
End Date:
June 13, 2017
May 24, 2017
When I select the filter to show March onwards(which is outside Start Date) records, the aggregation works properly but not the other filters. See screenshot.
I'm heading out for the rest of the day but will try to have a look at this for you later tonight.