Compare two date dimensions using Set Analysis Expression

[Tanya_24]

Hi All

I have all the columns as date columns instead of Invoice Amount column. I am trying to do the sum of Invoice Amount based on the below condition, but it is not working for me.

1st condition : I want to check Product Start Date and Sales Date is not null.

2nd condition : I want to check  Approval End Date less than Product Expiry Date.

Set Analysis Expression :-

Sum({$< [ Product Start Date ]={"*"}, [Sales Date]={"*"},[Approval End Date] = {"<=$(Date('[Product Expiry Date]', 'DD/MM/YYYY'))"}>}[Invoice Amount])

Sum I am getting is : 158,050.58 but Expected result is : 156,537.08

All Date formats are in (DD/MM/YYYY)

Would Appreciate for the help!:) 

[Tanya_24]

This expression is not working as it is giving sum of 5 lakh something.
Just wanted to know will set analysis work if columns are present in two different tables and there is no easy link between them?

[tresesco]

Mostly not. In such cases, if structure is a better bet. However, you have to still validate and understand the association correctly, i.e. - the granularity, ...