Set expression passing island date field in table expression

[shwethaa]

I have island Calendar table.

I have pulled island date week in the straight table. so in measure I want to pass sum of sales where main date week=island date week.

[Uday_Pasupuleti]

Try

date week=P(island date week)

[sunny_talwar]

You might need to use if statement here

[shwethaa]

No if statement doesn't work, because dimension in the table is Island date field, so I want to show data related original date in front of this island field.

[sunny_talwar]

Would you be able to share a sample where we can see the issue?