Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi All
All the while master cal end date i set to 2020 , But i need to add sales target amount 2021 , in order to make sales target for 2021 appear , i need to set master cal end date to 2021 , but when sales LYTD amount display null. see below image :-
When i Set the master Cal end date to 2020 , I cannot view the sales Target 2021 amount But Sales LYTD is okay :-
Hope some one can share with me where go wrong ?
Paul
Solved! Go to Solution.
@Paulyeo11 What is the measure for your Sales LYTD please?
You should add a date context to the visual or report, so that the table knows what year you want to display sales for, otherwise time intelligence functions don't behave as we expect.
Copying DAX from this post? Click here for a hack to quickly replace it with your own table names
Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C
I work as a Microsoft trainer and consultant, specialising in Power BI and Power Query.
www.excelwithallison.com
Paul,
It's not clear what you want to achieve. You want to calculate 2 measures one in the future and the other a running total in the past! whats the relationship between the 2 measures!
Attach a PIBX please
Regards
Amine Jerbi
If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook
Hi AJ
Thank you for sharing. I think Allison have pointed out the issue , i should not change the Master Cal end date , instead i should change the 2021 sales target expression :-
Glad to hear it even though i am skeptical in regards of the use of your DAX formulas.
Regards
Amine Jerbi
If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook
Hi AJ
Any way i am very appreciated very much you have help me solve few of the major issue.
Paul
@Paulyeo11 What is the measure for your Sales LYTD please?
You should add a date context to the visual or report, so that the table knows what year you want to display sales for, otherwise time intelligence functions don't behave as we expect.
Copying DAX from this post? Click here for a hack to quickly replace it with your own table names
Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C
I work as a Microsoft trainer and consultant, specialising in Power BI and Power Query.
www.excelwithallison.com
Hi Allison
You are good , you spot my mistake , now working fine.
Hi Allison
Thank you for your sharing.
I am lhearing to you said that i should not change the Master Cal date from 2020 to 2021 right ? instead i should focus on the 2021 sales target expression below to get the 2021 sales target right ? :-
@Paulyeo11 It is okay to change the calendar to include future dates (it often should) however, the Sales LYTD measure is the broken one in that case, so what is that formula please?
Copying DAX from this post? Click here for a hack to quickly replace it with your own table names
Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C
I work as a Microsoft trainer and consultant, specialising in Power BI and Power Query.
www.excelwithallison.com
Hi Allison
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
117 | |
101 | |
71 | |
61 |