Forum Discussion
pani_victoria
Helper III
Helper IIIunion 2 tables with date condition
Hello colleagues! I have two tables. One table with one set of dates (01/01/15 - 07/22/24), the second table with another set of dates (07/15/24-07/23/24). I want to merge these two tables...
Hi, pani_victoria
Thanks for DAX_Machine and ryan_mayu reply. If you have not find the suitable dax, you can try this.
NewTable = FILTER( 'Table 2', NOT('Table 2'[Date] IN VALUES('Table 1'[Date])) )Best Regards,
Yang
Community Support TeamIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!How to get your questions answered quickly -- How to provide sample data in the Power BI Forum
ryan_mayu
Super User
Super Useryou can try this
Table 3 =
VAR _list=DISTINCT('Table 1'[Date])
return union('Table 1',FILTER('Table 2', not 'Table 2'[Date] in _list))
pani_victoriaHelper III
Helper IIIThanks! i'll try it