Help with calculating # of open task backwards based on already applied filters

[Matt_0311]

Hello everybody, it would be great if somebody could help me with some code that is calculating the amount of open task backwards (i.e. development week over week).

I have one table with let's say one task per line. Every job has two date fields (1. task created // 2. task completed).

I am already filtering the table for several visuals (i.e. displaying adherence to plan, leadtimes etc.). I would now like to display the mount of open jobs backwards as I am now only able to display the amount of open jobs today on one card.

Happy to receive any kind of proposal for i.e. calculating a measure for that ... 

Thx

Matt

[amitchandak · Accepted solution]

@Matt_0311 , see if this blog can help

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

or

Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

[Matt_0311]

@amitchandak - Hi amitchandak, I have one additional question to the example. I do have a relation between the field "task completed" and time table. The formula is only working if I have my switch this existing connection to inactive and create a new connection between "task created" and the time table. Problem is that all other visuals and calculations are then not working anymore. Is there anther way to overcome this?

[amitchandak]

@Matt_0311 , if you make an active join inactive in Model view, you need make sure all formulas that need this join should has userelationship to make sure they can work with inactive join

[Matt_0311]

Hi @amitchandak , Thx for quick feedback. Any chance to just deactivate a join within one formula so that I do not need to change all other formulas that need this specific join? Another option would obviously be to have a second date table only for this measure. Just wanted to avoid this.

[Matt_0311]

Thx @Anonymous  ... this is exactly what I was looking for. And it works ... 🙂