Data Manipulation

[Anonymous]

Hello fellows,

I'm trying to create a new variable from two diffent tables. I edited the relationship. However, the new variable that I need it is like the following one:

Table1

variable3: Clos_Date: mm/dd/yyyy

Table2

variable2: FYRf: wholenumber

The new variables 3: =YEAR(´table1'[Clos_Date])+if(MONTH(´table1´[Clos_Date])>=10,1,0)

Is it OK?

Thank you in advance for your help 🙂

[v-sihou-msft · Accepted solution]

@Anonymous

In this scenario, I don't see the Table2 column is involved in your new variable. If this is One-to-One mapping, it supposes to work if you already build the relationship properly. If it still doesn't work, you can consider using LOOKUPVALUE() in your formula. Also see this blog: https://www.sqlbi.com/articles/from-sql-to-dax-joining-tables/

Regards,