Hi, I have a purchases table and suppliers table and want to classify every supplier by the value of purchases dynamically depending on the selected period. I tried to add a calculated column to a suppliers table with the formula:
clasification = SWITCH(true(),
[totalValue] >0 && [totalValue] <45, "A",
[totalValue] >46 && [totalValue] <65,"B","C")
but it works staticly, how can i change the solution for dynamic?