Showing results for 
Search instead for 
Did you mean: 
olavamd Frequent Visitor
Frequent Visitor

Create a month table with existing projects



The reason im trying to create this table is because:


- My goal is to make a diagram pr. month that shows risk change in the balance as accumulated values across all projects.

My problem occurs with the financial transactions which in not all months have a transaction (for example one project can only have a change 4 months a year instead of all 12, then it wouldnt be a problem. The months in between then shows a zero value instead of the last one. If you have a quick solution i would love it.


Im trying to solve it by automatically create a monthly table with for example 201801-202801 and then use columns b, c, d to list every projects accumulated value pr. month and then make the table.




            Project A - Project B

201801 500'           200'

201802 1000       

201803                   250'

201804 1100          300'



Community Support Team
Community Support Team

Re: Create a month table with existing projects



Just drag date from a calendar table that has relationship to your table.

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Power BI Helps Homeless and Trouble Youth

Power BI Helps Homeless and Trouble Youth

We spoke with Power BI Super User, Greg Deckler, about his charity work

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 6 members 3,027 guests
Please welcome our newest community members: