Forum Discussion
Calculate Current Year Sales
Hi Experts
I am trying to calculate current year Sales Dynamically - I am using the following measure which is returning zero..
CurrentYear = CALCULATE(
SUM('Test Data'[sales]),
FILTER(ALL(
'Test Data'),YEAR('Test Data'[sales])=YEAR(TODAY())))
I have a DimDate Table which link to my Sales Table.....
Date
Year Date Sales
2020
2020
2021
2021
Hi Anonymous ,
First of all create a calculated column in Test Data table like this..
IsCurrentYear = VAR TodayDate = TODAY () VAR CurrentYear = YEAR ( TodayDate ) RETURN 'Test Data'[Date Column] >= DATE ( CurrentYear, 01, 01 )This column will return true or false..
After this create a measure like this...
Measure = VAR CurrentYearSales = CALCULATE ( SUM ( 'Test Data'[sales] ), 'Test Data'[IsCurrentYear] = TRUE () ) RETURN IF ( CurrentYearSales = BLANK (), 0, CurrentYearSales )If this works, kindly mark it as a solution. Appreciate with Kuddos.
3 Replies
Angith_NairContinued Contributor
Hi Anonymous ,
First of all create a calculated column in Test Data table like this..
IsCurrentYear = VAR TodayDate = TODAY () VAR CurrentYear = YEAR ( TodayDate ) RETURN 'Test Data'[Date Column] >= DATE ( CurrentYear, 01, 01 )This column will return true or false..
After this create a measure like this...
Measure = VAR CurrentYearSales = CALCULATE ( SUM ( 'Test Data'[sales] ), 'Test Data'[IsCurrentYear] = TRUE () ) RETURN IF ( CurrentYearSales = BLANK (), 0, CurrentYearSales )If this works, kindly mark it as a solution. Appreciate with Kuddos.