Forum Discussion
Fiscal Year Calculation`
you can also use this measure to get the same data
Sales YTD = VAR __SUM = CALCULATE ( [Amo], VAR FirstFiscalMonth = [StartFY] -- Set the first month of the fiscal year VAR LastDay = MAX ( 'Calendar'[Date] ) VAR LastMonth = MONTH ( LastDay ) VAR LastYear = YEAR ( LastDay ) - IF ( LastMonth < FirstFiscalMonth, 1 ) VAR FilterYtd = DATESBETWEEN ( 'Calendar'[Date], DATE ( LastYear, FirstFiscalMonth, 1 ), LastDay ) RETURN FilterYtd) VAR _MaxdareSales = MAX('Sales'[Business Days]) RETURN IF(_MaxdareSales,__SUM)
Hi ak77
You can use some conditions like :
If (month(max('yourtable[yearend]))= 3,
FYTD =CALCULATE([Total ReturnV1],DATESYTD('Date Table'[_Date],"31/03")),
FYTD =CALCULATE([Total ReturnV1],DATESYTD('Date Table'[_Date],"31/12"))
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
Ritaf1983 , thanks for reply.. can i use FYTD =CALCULATE([Total ReturnV1],DATESYTD('Date Table'[_Date],yourtable[yearend]) the year field as the parameter to the function?
Hi ak77
The suggested way is not correct for sure because 'yourtable[yearend]' is a column and not a scalar value, so you can't filter by it ( because the column is a multiple values and not one).
You can try to modify it to :
FYTD =CALCULATE([Total ReturnV1],DATESYTD('Date Table'[_Date],max(yourtable[yearend])
just try, there is no way a computer can defeat you 🙂