User parameters from another table in a calculated field dax query

[CloudMonkey]

Hi,

I have a table of every day's date and a table with the date of every public holiday. Please can you tell me how to created a calculated field to in the first table - returning a 1 if the date is not a public holiday and a 0 if the date is a public holiday.

Thanks,

CM

[CloudMonkey]

Thanks Phil, RELATED did the trick 

[Phil_Seamark · Accepted solution]

Hi @CloudMonkey

You can probably do it a number of ways.  One option is to merge the two tables in the Query Editor to effectively create a single table that contains both.

You can also do this in DAX as well.

Another option is to create a relationship between the two tables in DAX and create a calucated column that uses either RELATED/RELATEDTABLE fuctions to go fish for the values.

If you provide a sample data set of your two tables, we can try and help you out.

Cheers.