Calculate a sum from specific range in different periods from the same table

[Dfalfonso7_]

Hi

I have a database and in certain periods I have savings when a criterion is met, but that criterion is fed into an excel in which the intervals are defined, this variable is external to my database, I need to add the savings each time that this product is within the range of dates defined in excell, when I have a single period the filter.betwen function works for me, but when I have more than one period it does not allow me to do the operation, for now I have to create a table in excell with the date day by day to be able to relate it to the main table to be able to filter and calculate the savings, I would like not to have a day by day table, but one where I define the start and end date of that product and that in a month that same product Submit the savings in another date range for one week.

Thanks 

[v-zhangti]

Hi, @Dfalfonso7_ 

Can you provide some sample data or simple pbix files? Sensitive information can be removed in advance. What kind of expected results do you expect? You can also show it with pictures.

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Dfalfonso7_ , Are looking to filter two date ranges?

refer

How to use two Date/Period slicers

https://youtu.be/WSeZr_-MiTg