summation of value between ranges

[Anonymous]

Hi All,

Below is my sample data,

Table1

Table2

Expected output:

for date filter (01-01-2020 to 29-02-2020)

for date filter (01-01-2020 to 31-03-2020)

 I need to dynamically filter Table1 between the start range and end range of 'No' column. The start and end range is given in Table2. I want to create a measure for column 'total', which is the summation of amount between 'No' ranges.

[amitchandak · Accepted solution]

@Anonymous , Create a new measure like this and check

sumx(filter(values(Table1[No]), Table1[No] >= min(Table2[Start range]) && Table1[No] <= max(Table2[End range]) ), Table1[Amount])

[Anonymous]

yes.......It worked out.

In that measure using sumx function, i have given sum(amount) as measure, which is created in table1 in expression part because it won't accpet columns.