Forum Discussion
Solved
Need Help with MAX Date with multiple conditions
Hello, I need some help regarding a calculated column which returns me the MAX(X) date with a second set of filters. I have basic knowledge on how to use the MAXX()-Expression for that, but I don'...
Crydus , A new column in a sales/transaction table
Price from item to sales =
Maxx(filter(Item , Item[Item Key] = sales[Item Key] && Sales[Date]>= Item[Valid From] && Sales[Date]<= Item[Valid To]) , Item[Price])
Crydus , A new column in a sales/transaction table
Price from item to sales =
Maxx(filter(Item , Item[Item Key] = sales[Item Key] && Sales[Date]>= Item[Valid From] && Sales[Date]<= Item[Valid To]) , Item[Price])