How to get 2021 target amount ?

[Paulyeo11]

Hi All

My master claendar date set as below :-

Date = CALENDAR(Date(2000,01,01),date(2020,12,31))

My Target 2020 expression :-

Target_2020 = CALCULATE([TARGET_], DATESYTD(DATEADD('Date'[Date],-0,YEAR)))

In order to get Target 2021 expression , i have try , i cannot get 2021 Target :-

Target_2021 = CALCULATE([TARGET_], DATESYTD(DATEADD('Date'[Date],1,YEAR)))

it return 2020 Target.

Target_2021 = CALCULATE([TARGET_], DATESYTD(DATEADD('Date'[Date],-1,YEAR)))

it return 2020 Target.

May i know where go wrong ?

Only way is i need to change the below year from 2020 to 2021 :-

Date = CALENDAR(Date(2000,01,01),date(2020,12,31))

Which i don;t want.

Paul

[VijayP]

I am referring the Date in Date Dimension you have created using Calendar or Calendarauto

[VijayP]

@Paulyeo11  I mean the (Date) is the dim table name and other field based on your data structure. 

The error because those fields were not part of your data hence you need to repalce your actual data field names to get the result

[Paulyeo11]

Hi Vijay

Are your ref to this Date :-

Or this Date :-

[VijayP]

@Paulyeo11 

Instead of using calendar , you can use Caledarauto function which takes care of the dates automatically
I think you have separate Target  and I assume [TARGET_] is a measure

then you can use filter formula CALCULATE([TARGET_],filter(all(dates),dates[year]=2021))
LEt me know whether that works

[Paulyeo11]

Hi Vijay

I try using your expression , i get error :-

[LillyLegenda · Accepted solution]

Hi Paul, maybe you can do 

Date2 = CALENDAR(Date(2000,01,01),date(2021,12,31))

and use that for 2021.

[Paulyeo11]

Thank you Lilly