Forum Discussion
Solved
If date is between 2 dates from another table return value
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....
ryan_mayu Maybe you can make sense of this - I literally copied and pasted the same fiscal calendar data into your sample file (power query) as a new data source and used the same formulas you did, replacing your fiscal calendar table column with the new ones, and I'm getting different results: