Reporte de Power BI

[JesusMtzN]

Hello good morning.

I have the following databases, my main table is the one called "new_seguimientocotizacion" and my secondary tables are "new_seguimientodecotizacion" "annotation".

From my parent table to my table called "annotation" I have a 1 to many relationship, and in my report I want to see the most recent record of the "creation date" of the table "annotation" related to my record, I already achieved that , but now my problem is that if one of my records in the main table does not have any record associated with the "annotation" table, it does not show it to me in my report and I want to see if my record has or does not have an associated "Date of creation" of the "annotation" table.

I show two examples where I remove and add the field called "Last Modified" which is where I do my debugging so that it shows me the last "Creation Date" of the "annotation" table associated with my main table record, I have two sellers, one With 3 records and the other with 1, the first seller did create a record from the "annotation" table and the other did not. When I add or remove the "Last Modified" field, that seller who has not created a record of the "annotation" table disappears and appears and I want it to show me those who do and do not have a "Creation Date" of the table " annotation" associated with a record from my main table.
​

[v-zhangti]

Hi, @JesusMtzN 

With your description it should be possible to do it in Power BI Desktop. Can you simplify your data and provide sample data and outputs? You can also show it with Excel.

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.