I have a Fact table "Reporting AllPolicies(Yellow Table) and I want to filter that base on that based on the users selection on the slicer "Accounting Date (Green Drop Down).
I have added a measure on the Yellow table to get the selected value from the slicer ("_SelectedDate")
Then I have added a new column and thought a basic if statement would allow me to filter the results.
See formula "_InForce" =
Solved! Go to Solution.