Calculate Current Year Sales

[Anonymous]

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

[Anonymous]

Hello @Anonymous ,

try with the measure

CurrentYear = CALCULATE(
SUM('Test Data'[Sales]),
FILTER(ALL(
'Test Data'),'Test Data'[Year]=YEAR(TODAY())))

[Angith_Nair · Accepted solution]

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.

[Anonymous]

Thanks