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.
I have a target for the sales team to hit on a quarterly basis but I need to know where they should be at this time of quarter i.e. are they on target or not? i.e. the maximum on the guage can be set as a the target and then the 'target' on the guage will be how far through the quarter we are based on today's date as a percentage on the whole quarter multiplied by the total target.
Is this possible to make the target a formula of this nature on the guage?
Many thanks in advance,
Alex
HI @alexsimpson,
If you want to create a dynamic target based on current date, you can take a look at below formula.
dynamic target = var todayAmount=LOOKUPVALUE('Sample Table'[Amount],[Date],TODAY()) var QuarterAmount=SUMX(FILTER(ALL('Sample Table'),[Date].[QuarterNo]=VALUE(FORMAT(TODAY(),"q"))&&[Date].[Year]=YEAR(TODAY())),[Amount]) var target=SUMX(FILTER(ALL('Sample Table'),[Date].[Year]=YEAR(TODAY())),[Amount])/4 return todayAmount/QuarterAmount*target
Regards,
Xiaoxin Sheng
Hi Xiaoxin,
Thanks so much for your reply. I have tried to use that formula but it is not registering anything? Do you know what I am doing wrong?
Many thanks in advance.
Alex
Hi @alexsimpson,
I found you have calculate on 'date' column instead of the amount, I think the issue may related to it.
If above not help, can you please provide some sample data to test?
Regards,
Xiaoxin Sheng
Hi Xiaoxin,
Thanks for your reply. I have copied your formula exactly as shown below. So sorry about this, I am sure it is simple but it just wont work at the moment but you obviously managed to get it to work.
Thanks,
Alex
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 |
---|---|
97 | |
96 | |
81 | |
74 | |
66 |
User | Count |
---|---|
126 | |
106 | |
105 | |
86 | |
72 |