Maintain data / Remove duplicates based on the earliest date

[Syndicate_Admin]

Good morning

I am new to PBI and I have the following challenge: uni the information of two tables; Table 1 is my database, contains list of styles, names (s23 custom), available units; table 2 contains PO (orders), units per order, units in transit, arrival date, etc. (contains + of 100 columns), However, a style can have more than one order; Extract the information from Table 2 to create the dashboard using Table 1.

What I need is: consolidate into one table, S23_custom. style color, available units, PO (with the most recent date of arrival, if there is more that does not show them), date in the DC, Ontime / late (I have a condition already for this), order quantity, units in transit, among others.

Here my situation, in the second image, when I add inbound PO_order, remove the styles that do not have PO but do have units available. Also if I remove styles that have more than one PO I remove those that do not have PO.

If anyone can help me, I thank them.

[Anonymous]

Hi @Anonymous ,

If you mean to hide the records on the second table based on records id, you can consider writing a measure formula to check current id to compare with the first table records and return tag. Then you can use it on 'visual level filter' to filter records.

Regards,

Xiaoxin Sheng

[yyzheng12]

It's not clear to me what you want to achieve. You can use the filter function to filter out row data.

[Syndicate_Admin]

Thanks for replying.

the goal is to show the list styles with available units, list of POs without showing duplicates and the information of the rest of the columns, this will help me to create a summary table.

I have several phylls, with these in a different table I can know how many styles it does not have PO, but I need to consolidate