Bring in a column from another table

[Yrstruly2021]

I would like to bring in the holiday column from my pholiday tables to the calendare table. Please assist?

pbix https://drive.google.com/file/d/1CBpFLkw37E5aeYSG9RXMLTzOXUCdcn4m/view?usp=sharing  data https://drive.google.com/file/d/1iP2DhQ5QCrpmTX0_odz2sEXXLMs9FiEg/view?usp=sharing 

[Jihwan_Kim]

Hi, @Yrstruly2021 

Please try the below, for creating a new column in the Calendar Table.

Holiday Column =

LOOKUPVALUE( PHolidays[Holiday], PHolidays[Data], 'Calendar table'[Date])

Hi, My name is Jihwan Kim.

If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

[Yrstruly2021]

Thak you. Please confirm if my star schema is correct and suitable for filtering and cross filtering among tables? https://drive.google.com/file/d/1CBpFLkw37E5aeYSG9RXMLTzOXUCdcn4m/view?usp=sharing 

[Jihwan_Kim]

Hi,

Thank you for your feedback.

It is difficult for me to say about your data model without understanding your business.

One thing I can suggest is, you can delete the relationship between the holiday table and the calendar table.

Thanks.