Forum Discussion
Solved
Dynamic Fiscal Year
Hello, I am trying to create a dynamic count # of cases closed in a fiscal year (October to September) Current Fiscal Year Count = VAR CurrentDate = TODAY() VAR CurrentFiscalYear = IF(MONT...
is this what you want?
Count of Case for 2023 = VAR _year=CALCULATE(max('DIM Calendar'[Fiscal Year]),ALL('DIM Calendar'))-1 return CALCULATE(COUNT('Fact Table'[Case]), FILTER(all('DIM Calendar'),'DIM Calendar'[Fiscal Year]= _year)) Count of Case for 2024 = VAR _year=CALCULATE(max('DIM Calendar'[Fiscal Year]),ALL('DIM Calendar')) return CALCULATE(COUNT('Fact Table'[Case]), FILTER(all('DIM Calendar'),'DIM Calendar'[Fiscal Year]= _year))
Thank you so much, I appologize in my response delay!
you are welcome