Comparing a column with various dates with a column with only one date

[Anonymous]

Hi guys,

I am using the function calculate and in one of the ifs I want to make something like 'Table1'[Dates]>='Table2'[Date]. The problem is that Table 2 has only one line, is it possible to make this date in table 2 dynamic? Because the only solution I have come accross so far is to put mannually the data myself by using the function DATE.

Also, another idea that I had was to make a column in Table 1 where the column has only the date from table 2 in every line, but I don't know how to make that as well.

Thank you

[johnt75 · Accepted solution]

If you know that Table 2 will only ever have 1 line then you could use 'Table 1[Date] >= SELECTEDVALUE( 'Table 2'[Date])