Forum Discussion
Memorable MemberHow to make Target amount for 2022 amount display ?
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 :-
Hope some one can advise me where go wrong ?
Paul
admin11 , Your table name is Traget_ please correct that
Target_2022_ = CALCULATE([TARGET_], Filter('TARGET_', year('TARGET_'[Date_t]) =2022 ))
6 Replies
- amitchandak
Super User
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 ))
admin11When i try below expression :-
Target_2022_ = CALCULATE([TARGET_], Filter('Table', year('Table'[Date_t]) =2022 ))I get error msg below :-- amitchandak
admin11 , Your table name is Traget_ please correct that
Target_2022_ = CALCULATE([TARGET_], Filter('TARGET_', year('TARGET_'[Date_t]) =2022 ))
- admin11
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