Latest entry in the report

PC2022 — Tue, 03 Dec 2024 18:34:17 GMT

I have multiple "planned activities" entries in my Dataverse (Project for the Web). On the report i need to indicate the latest entry. How would i do it?

Re: Latest entry in the report

FreemanZ — Tue, 03 Dec 2024 21:11:41 GMT

hi PC2022 ,

try like:

measure =

MAXX(

TOPN(1, data, data[date]),

data[plannedactivities]

)

Re: Latest entry in the report

Jihwan_Kim — Thu, 05 Dec 2024 04:47:24 GMT

Hi,

I am not sure how your semantic model looks like, but if you want to approach to this in Power Query Editor to create [latest_flag] column, one of ways is to try something like below.

Please check the below picture and the attached pbix file.

let Source = project_source, #"Sorted Rows" = Table.Sort(Source,{{"reportingdate", Order.Descending}}), #"Grouped Rows" = Table.Group(#"Sorted Rows", {"group"}, {{"latestreportdate", each List.Max([reportingdate]), type nullable date}}), Custom1 = Source, #"Merged Queries" = Table.NestedJoin(Custom1, {"group"}, #"Grouped Rows", {"group"}, "Custom1", JoinKind.Inner), #"Expanded Custom1" = Table.ExpandTableColumn(#"Merged Queries", "Custom1", {"latestreportdate"}, {"Custom1.latestreportdate"}), #"Added Custom" = Table.AddColumn(#"Expanded Custom1", "latest_flag", each if [reportingdate] = [Custom1.latestreportdate] then 1 else 0), #"Removed Other Columns" = Table.SelectColumns(#"Added Custom",{"group", "plannedactivities", "reportingdate", "latest_flag"}) in #"Removed Other Columns"

Or, if you want to approach to this problem by creating calcualted column, please check the below picture and the same attached pbix file.

latest_flag CC = VAR _group = project_source[group] VAR _reportdate = project_source[reportingdate] VAR _flagtable = SELECTCOLUMNS ( FILTER ( ADDCOLUMNS ( project_source, "@RankByLatest", RANK ( SKIP, project_source, ORDERBY ( project_source[reportingdate], DESC ), , PARTITIONBY ( project_source[group] ), MATCHBY ( project_source[group], project_source[plannedactivities], project_source[reportingdate] ) ) ), [@RankByLatest] = 1 ), "@group", project_source[group], "@latestdate", project_source[reportingdate] ) RETURN COUNTROWS ( FILTER ( _flagtable, [@group] = _group && [@latestdate] = _reportdate ) )

Re: Latest entry in the report

PC2022 — Mon, 09 Dec 2024 16:43:58 GMT

This worked! Thank you!

topic Re: Latest entry in the report in DAX Commands and Tips

Latest entry in the report

Re: Latest entry in the report

Re: Latest entry in the report

Re: Latest entry in the report