mihzukFrequent Visitor2 years agoValue on last date Hi, I need a measure that calculates the sum of quantities on the latest available date. This is my example table: Item1 Location1 QTY1 Date1 A X 1 2.2.2023 C X 1 2.2.2023 ...Show More
FowmySuper User2 years agomihzuk Check the attached PBI file for the meaure and the data model: Value on last date.pbix32 KB
mihzukFrequent Visitor to Fowmy2 years agoThat works great until I put Item as a filter. Then it brings me back to latest QTY that I have in my table. Example Latest value should be 0 since there is no QTY on 02.02.2023.Could you look into that? Thank you!
Related contentDate Different return wrong valueValues not averaging correctly based on dateDynamic Value Date formattingDates Between slicer default value to MAX dateReplace date values before specific date or error value to Null
