Relationship - Calendar to single table with montly/weekly/daily values

[jhayes0128]

I have a single table [Table1] that I need to join to my calendar table. [Table1] contains both budget/LE/actuals at different time intervals.

[Table1]

Date	Type	Value
1/1/2021	Budget	50
1/1/2021	LE	60
1/1/2021	Actual	1.1
1/2/2021	Actual	1.4
1/3/2021	Actual	1.2
1/4/2021	Actual	1.5
1/5/2021	Actual	0.9
1/6/2021	Actual	0.5
1/7/2021	Actual	1.7

[Calendar]

Date	Week	Month
1/1/2021	12/28/2020	1/1/2021
1/2/2021	12/28/2020	1/1/2021
1/3/2021	12/28/2020	1/1/2021
1/4/2021	1/4/2021	1/1/2021
1/5/2021	1/4/2021	1/1/2021
1/6/2021	1/4/2021	1/1/2021
1/7/2021	1/4/2021	1/1/2021

I have a relationship between [Table1]Date and [Calendar]Date. This works fine for looking at measures at a monthly level, but not at a weekly/daily level due to this relationship.

How can I write a measure where each day has Budget = 50?

[lbendlin · Accepted solution]

Compare the YearMonth value of the calendar date to the YearMonth value of the Date in Table1 and fetch the budget value.