MatrenFrequent Visitor2 years agoSolvedDAX Last Record Value Hello Everyone, How could I write a DAX expression with existing columns (Date, Product, Value) to generate a new column (Last Record)? Basically, it is taking the last Value for a Product an...Show MoreThxAlot2 years agoLast Record.pbix18 KB
lbendlinSuper User to ThxAlot2 years agoSlight variation: Last = SELECTCOLUMNS(INDEX(-1,ALL('DATA'),PARTITIONBY([Product]),MATCHBY([Date])),[Value])
Related contentExpression.Error: We cannot convert the value "[Record]" to type List. Details: Value=[Record]Extract Values From a List of RecordsCreating a record from list valuesSorting RecordsEliminate duplicate records while keeping the most recent record.
