Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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
Solved! Go to Solution.
If you know that Table 2 will only ever have 1 line then you could use 'Table 1[Date] >= SELECTEDVALUE( 'Table 2'[Date])
If you know that Table 2 will only ever have 1 line then you could use 'Table 1[Date] >= SELECTEDVALUE( 'Table 2'[Date])
Check out the July 2025 Power BI update to learn about new features.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
User | Count |
---|---|
20 | |
7 | |
6 | |
5 | |
5 |
User | Count |
---|---|
24 | |
10 | |
10 | |
9 | |
6 |