MINIMUM DATE ON A COLUMN

[Syndicate_Admin]

Hello to see if you can help me,

I have a database with IDs, with accident types and the start date and end date.

In the visualization I put the ID, type of accident and the minimum or maximum of the start date that is less than the date selected in the slicer but there are IDs with the same type of accident but with different dates and I do not see all the start dates, the IDs with the type of accident are the same grouped.

how can I do it?

Thanks a lot.

[amitchandak]

@Syndicate_Admin , Not very clear , You should all these column as un summarized on visual

ID, type, Start date, end date

Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

[Syndicate_Admin]

Sheet 1 is the original data and sheet 2 is the output data

https://docs.google.com/file/d/1abFC-W7zfwxw4EL5LAVdvgLbifyagAM1/edit?usp=docslist_api&filetype=msex...

[v-stephen-msft · Accepted solution]

Hi @patycnt ,

Put the Empleado column, the Subtipo column and the FECHA INICIO column into the table, and then select the Latiest for the FECHA INICIO column.

Check more details from the attachment.

Best Regards,

Stephen Tao

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

[v-stephen-msft]

Hi @patycnt ,

I need permission to access excel, I have applied for it.

Best Regards,

Stephen Tao

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