Calendar Date Filtered to show only "Periods" that exist in Fact table

[DMercier]

Date Filter from Fact Table.xlsx (44.2 KB)

Hi,

I have Fact tables with 1 “Date Field”:

1. “FY-Period” format of data is YYYY-Period Number: i.e.
   Jan 2021 = 2021-01
   Feb 2021 = 2021-02

I have a DIM table with 2 “Date Fields”

1. "FY-Period" format of data is YYYY-Period Number:  i.e.
         Jan 2021 = 2021-01
         Feb 2021 = 2021-02
   

2. "FYPeriodEnd" format of data is DD-MM-YY
         27-Jan-19
         24-Feb-19
   

See Relationship diagram
My goal is to have a slicer that shows ONLY FYPERIODEND values for Dates that EXIST in Fact table
the Fact table only has dates for FY 21 and will have FY 22, I prefer not to have make any changes to filtering when new dates are entered for FY 22

[Rajesh]

Hi @DMercier

Create a measure like below and use that measure in filter pane

[DMercier]

Rajesh,

Amazingly simple thank you!