How to make Target amount for 2022 amount display ?

[admin11]

Hi All

My PBI target table working fine in year 2021. since next 1 more week will be 2022 , i have update input target data for 2022.  As you can see from below image :- 

I am using below expression for display 2021 target by SBU , it work can return correct value :-

Target_2021_ = CALCULATE([TARGET_], Filter('DAte', year('Date'[Date]) =2021 ))

But when i try to use below expression to display 2022 target value :-

Target_2022_ = CALCULATE([TARGET_], Filter('DAte', year('Date'[Date]) =2022 ))

Hope some one can advise me where go wrong ?

Paul

[amitchandak]

@admin11 , I doubt you date table do not have dates for 2022 .

Please check that

Also, check using date from the table

Target_2022_ = CALCULATE([TARGET_], Filter('Table', year('Table'[Date_t]) =2022 ))

[admin11]

@amitchandak 

I think it is due to date for 2022 Jan 1 not yet arrive , one i have sales data date , the target value will appear , so i think need to wait . 

May i know windows 10 how to set the today date to 7 Jan 2022 ?

Paul

[admin11]

@amitchandak 

When i try below expression :-

Target_2022_ = CALCULATE([TARGET_], Filter('Table', year('Table'[Date_t]) =2022 ))

I get error msg below :-

[amitchandak · Accepted solution]

@admin11 , Your table name is Traget_ please correct that

Target_2022_ = CALCULATE([TARGET_], Filter('TARGET_', year('TARGET_'[Date_t]) =2022 ))

[admin11]

@amitchandak 

I just check and it work fine now.  Thank you very much

Paul

[admin11]

@amitchandak 

from below image , you ccan mentioned that my table name is TARGET not TRAGET