Forum Discussion

junyetzotomayor's avatar
junyetzotomayor
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's avatar
junyetzotomayor
Helper I
9 years ago

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.

 

Phil_Seamark's avatar
Phil_Seamark
Microsoft Employee
9 years ago

I'm heading out for the rest of the day but will try to have a look at this for you later tonight.

  • Phil_Seamark's avatar
    Phil_Seamark
    Microsoft Employee
    9 years ago

    Hi junyetzotomayor,

     

    Any chance you can send me a cut down version of your PBIX file?  Feel free to private message me the link. This will make it much easier for me to figure out.  :)

     

    Cheers,

     

    Phil