How to use a For Loop in a Products Group

[Shweta]

 I have two tables like Lookup and Product .In these two tables have two different date Columns. I want to Calculate the sum of amount "column" of product table. If any date of product table lies between Lookup table date then I have to calculate that amount .Is there any possibility for something like a "FOR Loop"

[ankitpatira]

@Shweta To do this in powerbi you woudl need to consider using DAX. I would suggest if possible better do it at your data source level (if you have SQL data source it would be very easy to do this).