Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to Solution.
@admin11 , Your table name is Traget_ please correct that
Target_2022_ = CALCULATE([TARGET_], Filter('TARGET_', year('TARGET_'[Date_t]) =2022 ))
@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 ))
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
When i try below expression :-
@admin11 , Your table name is Traget_ please correct that
Target_2022_ = CALCULATE([TARGET_], Filter('TARGET_', year('TARGET_'[Date_t]) =2022 ))
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
100 | |
75 | |
73 | |
49 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |