Forum Discussion
DAX finding dates
Hello, I need to calculate 2 values using DAX function. 1. Calculate the penultimate date for product id 2. Calculate the quantity for a given date and product id. an example table with data is ...
Hello, actually the data was wrong. I am pasting the corrected ones now.
In this list, the maximum date is 24/04/2023.
However, I want to be able to calculate the next e.g.
22/04/2023 (max-1) and another 17/04/2023 (max-2), i.e. subsequent dates in a decreasing sequence. The function must include a filter for a specific product id.
At the same time, the result of this function is supposed to be a filter to find other values from a table row.
e.g.
date 22/04.2023 for product id 25, is to be a filter to the sales quantity for a given date and product id.
The data is still not good. There is no overlap.