Forum Discussion
Solved
Fiscal Year Calculated Columns from date ranges
I'm creating a date table and I've used the Calendar() function as the basis. So, I have a Date column in the Dates table, as well as other calculated columns for Month, Quarter, etc. I want to add...
This seems like it's giving me the results I need. Does anyone see any issues with this solution?
Fiscal Year = CALCULATE(VALUES(GLYEAR[FISCAL_YEAR]), FILTER(GLYEAR, Dates[Date] >= GLYEAR[START_DATE] && Dates[Date] <= GLYEAR[END_DATE]))
This seems like it's giving me the results I need. Does anyone see any issues with this solution?
Fiscal Year = CALCULATE(VALUES(GLYEAR[FISCAL_YEAR]), FILTER(GLYEAR, Dates[Date] >= GLYEAR[START_DATE] && Dates[Date] <= GLYEAR[END_DATE]))
Hi ChrisWilliams,
According to your description, the formula provided above should work in this scenario.:smileyhappy:
In addition, could you accept your reply as solution to help others who has similar issue easily find the answer and close this thread?
Regards