Measure Capability in Dataflows

Hello - I recommend you create a new dataflow which contain linked entities for the DimDate and Fiscal Date tables.  Then create a computed entity from DimDate and add the following to filter the DimDate range based on the Fiscal min/max dates:

DimDate

Fiscal Dates

RESULT

SCRIPT

let
Source = DimDate,
Filter = Table.SelectRows (
        Source,                                                  // Name of the table from the prior step
        let                                                                    // declare variables with the scope table (ChangeTypes)
            minDate = List.Min ( FiscalDates[Date] ),  // TableName[ColumnName], returns a list of dates
            maxDate = List.Max ( FiscalDates[Date] )  // TableName[ColumnName], returns a list of dates
        in                                                                      // end the declaration at the table scope level
            each                                                             // iterate each row
            [Date] >= minDate                                      // compare the date in each row to the declared min/max
            and [Date] <= maxDate
    )
in 
Filter