So i am working on a contract budget report and i need to be able to filter the sum of distributions(measure) by the contracted START and END dates. However there are some caveats;
distributions = ORA data source
issue date (dates that are contributed to distributions) = ORA data source
start and end date = excel template
At first i wanted to do something like;
IF issue_date BETWEEN (start_date, end_date)
BUT i want to do something like
SUM (distributions) for all issue_dates BETWEEN(start_date, end_date)
data is confidential, however i can try to mock something up if needed.
Yes, it' way easier to investigate with sample data.
Could you attach it as twbx format.