Forum Discussion
Contains date
Hello! I got a bunch of date like this And I Would like to have the year coresponding of the date column but only if there are all month between april/N to mars/N+1. For exemple if there ar...
Anonymous ,
If I understand correctly, your date column doesn't contain different days, just different months per different years.
Please, try this measure, worked for me with the next data structure:
#FY2 = VAR currentYear = IF(MONTH(SELECTEDVALUE(T[Date])) < 4, YEAR(SELECTEDVALUE(T[Date])) - 1,YEAR(SELECTEDVALUE(T[Date]))) VAR monthsInCurrentYear = CALCULATE( DISTINCTCOUNT(T[Date]), FILTER( ALLSELECTED(T), currentYear = IF(MONTH(T[Date]) < 4, YEAR(T[Date]) - 1,YEAR(T[Date])) ) ) VAR Result = IF(monthsInCurrentYear = 12, currentYear, 0 ) RETURN ResultIf this post helps, then please consider Accept it as the solution ✔️to help the other members find it more quickly.
ERD
Community Champion
Community ChampionAnonymous ,
The code from the example above is (calculated column):
FY_cln =
VAR currentYear = YEAR(T[Date])
VAR monthsInCurrentYear =
COUNTAX(FILTER(ALL(T[Date]), YEAR(T[Date]) = currentYear), MONTH(T[Date]))
RETURN
IF(monthsInCurrentYear = 12,
IF(MONTH(T[Date]) < 4, YEAR(T[Date]) - 1,YEAR(T[Date])),
0
)If this post helps, then please consider Accept it as the solution ✔️to help the other members find it more quickly.
just can i do it in a mesure? Because if i change the filter in the overview, it doesn't work anymore