Need help comparing Datespans

[Anonymous]

I have a data slicer where I can select a datespan and a table with roughly the following layout:

Start_date	End_date	Invoice name
01.05.2021	Null	Random Name1
01.03.2020	04.05.2021	Random Name2

I want to have two line diagrams. Both are suppose to have dates as their axis. The first one should show the amount of unfinished invoices and the second one the average age of invoices in the selected datespan.

I have tried a couple of times but don't manage to get it working. I'm thankful for any kind of help.

[amitchandak · Accepted solution]

@Anonymous , expected output not clear

check current employee formula here

https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-trend/ba-p/882970

or this

https://community.powerbi.com/t5/Community-Blog/How-to-divide-distribute-values-between-start-date-or-end-date/ba-p/1503785