Forum Discussion
Helper IIIunion 2 tables with date condition
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
DISTINCT (
UNION (
DISTINCT( DATETABLE1[col] ),
DISTINCT( DATETABLE2[col] )
)
)
This formula should produce a table with distinct values of both tables.
Did I answer your question? If so please mark my post as a solution!
Helper IIIYes, this is an obvious solution, but it doesn't work for me.
In my case, 2 tables may have the same row in meaning, but with different data, therefore it will be unique for both tables, but in fact it will be a duplicate