Forum Discussion
Solved
Select latest rows
A background job pushes daily updates into Power BI (push dataset) via REST API. This looks similar to this: Product Version Issues Date ProdA 1.3 10 2022/07/21 ProdB 1.2 5 ...
You could create a table like
Latest Data = var maxDate = MAX('Table'[Date]) return FILTER( 'Table', 'Table'[Date] = maxDate )
You could create a table like
Latest Data =
var maxDate = MAX('Table'[Date])
return FILTER( 'Table', 'Table'[Date] = maxDate )