I have a DateTable with a list of dates and then I have the table below with fiscal year data: I'm trying to add columns to the DateTable to reflect the data from this fiscal year table. For the Financial Period I was able to use the below formula and it worked great: Financial Period w/ Dates = MINX( FILTER( 'Fiscal Calendar Data', 'Fiscal Calendar Data'[Start Date]<=DateDim[Date] && 'Fiscal Calendar Data'[End Date]>=DateDim[Date]), 'Fiscal Calendar Data'[FY Period Dates]) However when I try to use the same formula for the "Ship Days", the data returned is not correct (for P12 it returns the correct value of 20 but for all the rest of the dates it returns 19). I've tried many other suggestions (including this one) but I continue to get the error message: A table of multiple values was supplied where a single value was expected. Anyone have any other suggestions for how to solve this?

michaelho pls see the attachment to check if this is what you want

If date is between 2 dates from another table return value