Forum Discussion
dax function
Hello, I need to write a formula in dax that will calculate a date from a list of dates from a table. The formulas are supposed to take into account the product id filter: 1. the first function is t...
I guess I failed to check I have a list of dates.
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.