cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Carrying data over to next month

Hi everyone. I am trying to figure out how to carry over data from one month to the next. I am trying to create a stacked column chart for each month that includes:

 

1. total payments

2. total payments actioned (approved, denied)

3. paymetns from last month that are pending

3. payments from last month that got actioned this month

 

Here is a sample of my data:

Month

Payments

Status

July

4

P

July

3

P

July

2

P

July

7

P

August

1

A

August

9

A

August

2

D

 

I would want to include all pending payments in July on my August bar in the stacked column chart.

 

Thank you in advance for your help in advance.

4 REPLIES 4
Super User
Super User

Re: Carrying data over to next month

Well, mate, with this data you are not able to calculate what you want since there's no column that would establish the time sequence of your months. Sorry.

Best
Darek
Anonymous
Not applicable

Re: Carrying data over to next month

Hi, thanks for replying. Do you mind explaining what you mean by there's no column to establish time sequence?

Super User
Super User

Re: Carrying data over to next month

Well, how do you know that July precedes August? I know you do know but how is the code to know? If you have a Date table, the code knowns the time sequence between months because there is an integer column that tells that to it. But you do not have such a column, and hence the code cannot know.

Best
Darek
Highlighted
Anonymous
Not applicable

Re: Carrying data over to next month

Okay that makes sense. So if I make a date table will I be able to carry the data from one month to the other? If so, can you please help me with that?

Helpful resources

Announcements
Community Highlights

Community Highlights

Find out what's new in the Power BI Community!

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Virtual Launch Event

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Top Kudoed Authors
Users Online
Currently online: 168 members 2,057 guests
Please welcome our newest community members: