This is my problem :
I have a table of facts with "Indicateurs" :
- One column Month_Survenance
- One column Amount_Spent
- One column Index_Population (integer)
This table is linked with an other table "Population" (connection in both directions) :
- One column Index_Population
- One column PopulationAnd this table is also linked with a Date Table :- One column Month_Survenance
- One column End_Month_Survenance
I also create a disconnected table "Coding Month" :
The objective is to calculate the average amount spent per person month by month, and then to calculate a column that aggregates these amounts :
I want to create a measure"Cumulative_Amount_Spent_Per_Person" which should look like this :
The measures I have constructed are:
Are you calculating the cumulative value month by month? If possible, can you provide a simple file for us to test and provide accurate solutions.
You can also check if the solution in this thread could work for you.
Best Regards,Community Support Team _ Eason
Click here to read more about the December 2021 Updates!
Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.
Mark your calendars and join us for our next Power BI Dev Camp!