I have these two datasets e.g.
How would I add the Value column from Table 1 to Table 2? I've tried using Filter, Lookupvalue, Calculate, but cannot figure it out
Any suggestion would be much appreciated
Go to Solution.
new column in table 2
maxx(filter(Table1, Table2[Date] >= Table1[Start date] && Table2[Date] <= Table1[End Date]) , Table1[Value])
refer 4 ways to copy data from one table to anotherhttps://www.youtube.com/watch?v=Wu1mWxR23jUhttps://www.youtube.com/watch?v=czNHt7UXIe8
View solution in original post
Take a look at the September 2023 Power BI update to learn more.
Join Microsoft Reactor and learn from developers.