Target achievement based of monthly target and family product
Hello all, Please I am new and I need to create a target achievement in values as well in % for the team that should sum the daily revenues based on the family product name: Below the target as shown based on family based on daily input I need to calculate the reached value/family as well in %. In the below table "Customer Profile" there is the daily input of the sales activity pipeline. I have the account name (Created by email) as well , total monthly fee based on products. In the below table is the target values based on family products I have integrated as below: Thank you!
How many days left till the used value will reach the target?
Hello Community Team, I have a question related to the DAX formula. Following is my visualization. I have a line chart showing comparison between Actual and Target with: EPZ = external (in yellow), IPZ = internal (in blue) Prod used = actual (changing by day), Prod Capacity = target (stable data) By using this line chart, I can see data is growing in each EPZ or IPZ. But I want to have a card to predict how many days left (counting from the latest date) that the solid line with reach the dashed target line? Can you please help me out with a DAX formula? Thank you so much for your support!
Help Needed: DAX Measure to determine if SLA reached the target or not.
Hi Everyone, I'd like to ask for your help. I have data with different targets per SLA. Minimum column is also target but it's the minimum % an SLA must have. I created a measure that I will use to create an icon (using conditional format) to determine if the SLA Summary results met the target or not. _ConditionSLATarget = MAXX('Monthly Summary', IF('Monthly Summary'[_SLA Summary Results] >= 'Monthly Summary'[Target],1, IF('Monthly Summary'[_SLA Summary Results] >= 'Monthly Summary'[Minimum],0, IF('Monthly Summary'[_SLA Summary Results] < 'Monthly Summary'[Minimum],-1)))) ----------------------------------------------------------------------------------------------------- My Table is: 'Monthly Summary' SLA measure is _SLA Summary Results DAX Formula for _SLA Summary Results below: _SLA Summary Results = SUM('Monthly Summary'[Met])/SUM('Monthly Summary'[Volume]) However, there's something strange when I put it in a table. If you notice, DAT 1 SLA should be "-1" with a downward arrow because SLA Summary result of 85.32% did not meet the minimum target of 96% I don't know what went wrong so I'd like to ask for your expertise on this matter. Let me know if you need additional info. Thank you Here's a screenshot of my conditional format for the icons in case you need.Targetline on combochart
Hi, I would like to have a target line on a combo chart that shows the percentage from January. I have created a DAX measure as follows: target_line = DIVIDE ( CALCULATE ( COUNT ( Data[File No] ), FILTER( Data, Data[Compliant] = "Yes"), FILTER( datetable, datetable[FYMM] = 2201) ), CALCULATE ( COUNT ( Data[Compliant] ), FILTER( datetable, datetable[FYMM] = 2201) ) ) The result is correct, but when used as a line value, it only displays on the Jan-22 column rather than accross the entire yearTarget to date
Hello - I'm new to Power BI and DAX. I've strugged with figuring out the following. I have a start date for the project and a close date, and I created a column to calculate the total number of days. I've also got a total target column for those dates. If the total target is 1000, and yesterday was half way through the start and close dates, I'd like the target to be 500. If today's after the close date, I'd like the target to be 1000. For clarify, if today's the close date, and the project is open for 10 days, I'd like the target to be 900. In the example above, the target shouldn't be 3288 - it should be 1644 since we're half way through the dates that the project is open. Thank you in advance for your help!
Monthly Target
Hi I have a scenario like this. I have a fact table with 3 months worth of data. the monthly target is 70. Yearly target is 840. How do i compute for the Month over Month Target to check whether a respondent is meeting the monthly Target and would total to Year. Would love to know how I could solve the problem. the grain of data is daily and my target is monthly. The target table i just created it. and looks something like the below. MonthTarget January 70 February 70 March 70 April 70 May 70 June 70 July 70 August 70 September 70 October 70 November 70 December 70 Thanks in advance
