Sum with IF and conditions, different tables

[twister8889]

Hi guys,

How can solve this measure in Power BI? this measure is from QlikSense. I think that problem here is the different tables.

sum(
if(
if(
Table1[Dim] = 'A',
(Table2[Date1] <= Table3[Date2] and Left(Table2[Date1],4) = Left(Table2[Date2],4)),
Table2[Date1] <= Table3[Date2]
),
Fact1[Values],0
)

[v-deddai1-msft]

Hi @twister8889 ,

Would you please show us sample data and your expected output? For your formula, I don't know what's your really want.

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

Best Regards,

Dedmon Dai