Forum Discussion
extract the difference from 2 tables
hello I have 2 tables which shows Order number and I want to know which orders are not from one table to another
Example:
Table 1
| Norden | Estado |
| 5737987299 | Entregado |
| 5737987300 | Entregado |
| 5737987487 | Entregado |
| 5737988764 | Entregado |
| 5737980889 | Cancelado |
| 5737989724 | Anulado |
| 5737986432 | Entregado |
Table 2
| Norden | |
| 5737987299 | Ingreso |
| 5737987300 | creado |
| 5737987443 | pendiente |
| 5737988764 | Ingreso |
| 5737993811 | Ingreso |
| 5737989724 | creado |
| 5737982667 | creado |
there are equal Orders and another that are not in Table 1, how can I identify those that are not? in power bi
some easy mode, because my idea is to know if these orders are not in table 1 see in what state it changes later
Thanks
4 Replies
BEAT_CRETAMAL Use EXCEPT(Table2, Table1)
If I want to extract the date as well, how do I do it?
Hi BEAT_CRETAMAL ,
According to your description, I create a sample, is this your expected outcome?
Best Regards,
Community Support Team _ kalyjIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
hello when I run the DAX gives me the following
INF01_Ordenes_v2_2 [Norden] in this table are not all the orders of the unified table and those that are not I want to return them to make their analysisUnified Orders'[Nro_de_Negocio] this table has more orders would be the completehas a date column as well as create a calendar for its relationship in objectswhen I want to evaluate differences in Objects only the rest with a dax measure but I would like to know what differences there are between the 2 and those that are not in INF01_Ordenes_v2_2 bring them to meyour help is greatly appreciated I have tried several waysThank you
