Running count nutcracker.. (Trendline, running count, subtracting with multiple date tables).

[PaulusD]

Hi all,

I've got another nutcracker that I can't get my head around...

What i'm doing:

- I got a sharepoint list with actions, data is in a import set to pbi desktop

- every action has an entry date

- some actions have a closed date

I have a datetable for both dates (calender auto() expanded with month names etc.

relationships:

table named "Date" is marked as a date table.

I can't for the life of me figure out how to show the number of open actions per month in a trendline.

I've got the total actions in a graph:

how can I subtract the closed actions from this line, so it shows the progress over time?

Many thanks for yout support!

[Anonymous]

Hi

Could you tell me if your problem has been solved? If it is, kindly Accept it as the solution. More people will benefit from it. Or you are still confused about it, please provide me with more details about your requirement.

Best Regards,

Rico Zhou

[Anonymous]

Hi @PaulusD 

Do you want to see the values in this trend line per month?

You can try to turn on the data lable in this visual.

Best Regards,

Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. 

[amitchandak · Accepted solution]

@PaulusD , Your data model is not clear. Can you share sample data and sample output in table format?

refer My HR Blog: https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-tr...

https://www.youtube.com/watch?v=e6Y-l_JtCq4

[PaulusD]

Hi @amitchandak ,

It's clear to me ;-), it just doesn't work :P.

Your HR post is a nice topic,  i'll run through that and see if i can get it working with your tips.

Will let you know soon!