Forum Discussion
Dynamic calculation based on date slicer
I would like to perform a calculation which involves getting value from previous date. Also if the user selects a date value, I want to dynamically set the first value in that table to be set to a ba...
just add the region filter. (I messed with your sample data as it only had West region)
Thank you for your response. I tried the formula, it does work but I also need the ability to filter by the Postal Code. The Postal code is in a separate table with the region. I have a code table for the region which links to both the original table and the table with Postal Code. As soon as I add the Postal Code as a filter, the measure no longer works, it calculates the wrong value. The Postal Code is not part of the original table.
| region | postal code |
| west | A1B 2C3 |
| west | D4E 5F6 |
| east | G7H 8I9 |
