Calcucate Commission from a Range Table
Need help to add a calculated column for sales commission in each row of the Sales table. The commission % is determined by the total YTD revenue for the sales person for which the lookup range is in Target table. Example - For Person1 18-Dec-2024 - YTD invoice is 500, so commission @ 5% 13-Jan-2025 - YTD invoice is 2000 (Dec - 500+Jan - 1500), first 500 already paid in Dec, remaining 500 @5% and 1000 @ 6%. 24-Feb-2025 - YTD invoice is 4000 (Dec 500 + Jan - 1500 + Feb 2000) first 2000 already paid, remaining 1500 @ 6% and 500 @ 7% Total = 235Find duplicates between "date selected" and "date selected" - 30 days
Hi! 🙂 I have date filters (slicer) for year, month and day in a model that uses a table with [ID] and [Date] I want to show the duplicates between the "Date selected" and ("Date selected" -30 days) This is the table: If i select "December 1st, 2022" it should only show these: Thank you!
DAX Measure Based on Group and Range
Hello, I am attempting to write a DAX expression to assist in assigning a 1-5 value based on the performance of a representative, with 1 being "Far from Met" and 5 being "Significantly Surpassed." There are three different groupings: Alpha, Bravo, and Charlie. For example: So what I am looking to accomplish is assigning a 1 to 5 value based on the groupings illustrated above in one visual. I thought of this: IF('sheet name [Group] = "Alpha" && 'sheet name[Range] <425, 5 and so on for 4, 3, 2, 1 and repeat for the other two groups, however it's not working the way I thought it would. Any assistance would be greatly appreciated - if you have any additional questions, please let me know. Thanks, Andrew
Divide values by average of a period of time
Hi, I currently have a bar chart. - X axis: Year-Month - Y axis: count - Legend: categories Where at each x value I have multiple bars, one for each category. I have to divide the count value by the average value of that specific category. I have achieved this with the following DAX command: DIVIDE( SUM(programs[count]), CALCULATE(AVERAGE(programs[count]), ALLSELECTED(programs[date])) ) The problem is that I need to divide all the values by the average of the last three months. I have tried the following but it does not take into account different groups, it calculates the average of the last 3 months but even though the SUM(programs[count]) filters by category automatically, the average is calculated on all categories: velocity_variance = VAR latest_date = 21.06 VAR margin = 3 VAR start_date = CONVERT(latest_date - margin, STRING) VAR end_date = CONVERT(latest_date , STRING) VAR velocity = DIVIDE(SUMX(FILTER(programs, AND(programs[data] >= start_date, programs[date] < end_date)), programs[count]), margin) RETURN DIVIDE( SUM(programs[count]), velocity ) Based on this query, I can only think of creating a different average measure for each category but I don't want this because categories will change in the future and I have a lot. The programs table is of the shape: Date Count Category 20.01 34 A ... ... 21.12 654 C I hope someone can help me! (sorry about the code, the editor wouldn't let me add syntax highlighting) Thanks.Specific Date range for projects
Hello! I hop my explanation does this justice. I am doing a Cost Savings Projects analysis. It is a manufacturing plant, and we are changing aspects of the production to lower cost. For example, Project 101 may be changing a bag type and Project 102 may be changing labels. Each project starts a different day and runs for 52 weeks. so one project may be 3/1/2020-3/1/2021 and the other will be 6/2/2020-6/2/2020. What I need to be able to do is associate the Project ID with its product SAP and then have it only pull that project during the 52 weeks that the project is running, and anything outside of that specific range to be 0 or blank. But I have only been able to filter using the date filter, but i need it to filter specifically to the Project ID itself since they all have different savings goals and date ranges. Thank you !!!!
