Viewing Latest Logs

[Syndicate_Admin]

Hello, dear community, it happens that I need to filter from the following table in Power BI only the last "Name Status" in which a process is located. For example, from the "expense projection" process, only the most recent date comes out and not duplicated as shown in the image.

I have tried with the MAXX formula but it does not work for me, since it only brings the most recent records. Situation that is different, to bring the last stage of registration of a row.

[Syndicate_Admin]

Hello friend, thanks for your answer, however when performing the configuration you show me.

Only the records are obtained, of the most recent date, however if a record was made yesterday, I can not visualize it, basically I need to know the last stage update of each record, regardless of whether it is the most recent date. (The update may have been given yesterday or a month ago).

[andhiii079845]

You can add a filter via filter pane and you see only the earlist row.

Or you build a measure 🙂

[Syndicate_Admin]

Hello friend, thanks for your answer, however when performing the configuration you show me.

Only the records are obtained, of the most recent date, however if a record was made yesterday, I can not visualize it, basically I need to know the last stage update of each record, regardless of whether it is the most recent date. (The update may have been given yesterday or a month ago).

[andhiii079845]

Sorry, I miss understand it. You have to build a measure with RANKX and than you can filter it. If you have some sample data and the involved tables, I can help you. Please via the table function of the forum or better directly the PBI File via onedrive or dropbox.