bell curve

2 Topics

Creating a "weighted" bell curve measure
I have a table that roughly looks like this Program ID Sales Program Name Program Start Date Program End Date Units to Push 0001 ABC Aug-8th-2023 Aug-28th-2023 34 0002 DEF Aug-15th-2023 Sept-29-2023 57 003 GHI Sept-01-2023 Sept-29-2023 45 The users would like me to apply a bell curve to help them determine theoritically how many units to push per day depending on how far into the program they are (with an emphasis on the middle). So roughly the first 25% of the program they would be expecting to push more, same for the last 25% of the program, with the middle 50% expecting a bit of a lull. I've done so by creating several calculated columns: First one is a datediff between start and end date in days Second one is a division of Today minus start date over the total length of the program to get the progress of the program so far Third is the average units per day (total Units divided by number of days). With that I was able to create a calculated column with an IF Statement that basically checks what the Progress is and adds a modifier to the Average (minus or plus depending on where in the program). Weighted Sales = IF ( SalesProgram[ProgramProgress] <> 0 && SalesProgram[Program Length] > 10, IF ( SalesProgram[ProgramProgress] <= 0.25 || SalesProgram[ProgramProgress] >= 0.75, SalesProgram[AverageDailySales] * 1.5, SalesProgram[Average DailySales] *0.5 ), IF ( SalesProgram[ProgramProgress] <> 0 && SalesProgram[Program Length] <= 10, SalesProgram[AverageDailySales] ) ) note that they consider sales program under 10 days to just have average every day, no bell hence the extra logic for that My problem is that I've done all of this in calculated columns using TODAY as a checking point since they want to see their expectations for the day at the beginning, therefore I have no way to build a cumulative running total. How would I best go about transforming that calculation column into a measure that can track over tie (the table is connected to a calendar dimension)?
Solved
Anonymous
3 years ago Place DAX Commands and Tips
1.2KViews
1like
4Comments
Overlaying a bell curve on a histogram using DAX
Hi all! Noob here, so apologize if a similar thread already exists! 🙂 I'm stuck with the following issue: As you can see in the 1st pic. below I've plotted a histogram using a line & clustered chart. So far, all good. Now if try to plot the Gaussian Distribution on the same graph, I get errors saying there needs to be a relationship between the columns. I tried linking my "f(values)" column from the "UTS ND" table to the calculated column of "Start" from my "UTS filtering" table as it seemed the logical thing to do using a 1 to Many relationship, but the program doesn't allow because of a circular dependency. Had anyone else experienced a similar issue before? If so, how did you manage to overcome it? This is a job-related task that I've been struggling with for the past few days & I've ran out of ideas. :'( Thank you for every little bit of information!
Solved
Anonymous
4 years ago Place DAX Commands and Tips
13KViews
0likes
14Comments