Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Create a Calculated Column from Different Tables

Hi,   I have data as in the table below: I need period end dates (month end dates from jan to dec 2018). I was able to create a new table with the required dates. However for my further calculatio...
Need Help
Stachu's avatar
Stachu
Community Champion
7 years ago

if there is a join between the tables (e.g. 1:1, 1:many) you can reference them with:
RELATED when referring to the 1

RELATEDTABLE when referring to the many

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi Stachu,

 

I'll rephrase my statement.

 

I need to match year and month of live date and period end date. I am using the following formula (using related function) but it is not populating any data.

 

Column = IF(AND(YEAR(Table[LiveDate]) = YEAR(RELATED('Table2'[PeriodEndDate]), MONTH(Table[LiveDate]) = MONTH(RELATED('Table2'[PeriodEndDate], "New")

 

Can't find the error