Forum Discussion

jeremypmr's avatar
jeremypmr
Frequent Visitor
7 years ago

Sum if between dates

We have a table with unique rows containing: File Number, Lock Start Date, Funded Date, Loan Amount.   We are trying to create a visual that only shows the total count of how many files with the su...
Need Help
v-juanli-msft's avatar
v-juanli-msft
Community Support
7 years ago

Hi jeremypmr

I don't understand the rule of your output.

for example, file number 1, start from 2018/12/1 to 2018/12/30

it should go from week 48 to week 52, but in your output, it only goes from week 49 to week 51.

 

Best Regards

Maggie

  • jeremypmr's avatar
    jeremypmr
    Frequent Visitor
    7 years ago

    Sorry Maggie, The example wasn't accurate it was just scratched up to get teh idea across. Your rule is what we are looking for. Thanks!