projections

2 Topics

Need Help creating measure for maximum sum of a column for a projection
Hello I am trying to create a line graph visual that includes a projection of program enrollment over time (enrollment numbers on y axis, time on x axis). The project has 10 different sites enrolling patients to participate. The maximum number of individuals that can be enrolled by site is 130. I have the graph and I have the projection but I want to add a new measure that will cap each site at 130 so I can get an accurate estimate on timeline to study completion (enrollment= 1300). The dataset I'm using was designed for another purpose so it is in a less than ideal format but I think it can accomplish what I need. Below is a sample of the data table Table Name: Test Tab Site Name Timepoint Patient Enrolled (Cumulative) Site 1 January 2022 5 Site 2 January 2022 9 Site 3 January 2022 3 Site 1 February 2022 13 Site 2 February 2022 22 Site 3 February 2022 7
Solved
Cfrance28
4 years ago Place DAX Commands and Tips
422Views
0likes
1Comment
How to do projections for averages based off previous months for future months?
What I am trying to accomplish is the following: Doing projections for months that have not occured by using the past averages of those months like the following: In this picutre the projected december average is all the previous December average's and January is previous January etc. Here are the following tables and calculations I created 'Actuals :' 'Calendar' What I also need as well is if there is a number in there for the actuals already than it is blank. I have the following formula thus far: Actual Projections (12 MA) = IF( ISBLANK([Actuals :] ), Blank(), CALCULATE( Averagex( DATESINPERIOD ('Test Calendar'[Date], LASTDATE('Test Calendar'[Date] ), -12,MONTH), [Actuals :] ) )) But this is a moving average as Time currently stands Any advice????
Solved
Anonymous
4 years ago Place DAX Commands and Tips
3.7KViews
0likes
8Comments