Missing owners not assigned since X days

[ymirza]

I have this table below as an example, I want to show in powerBI report, since how many days from current date has the task not assigned with an Owner. The measure would start with "Not assigned since = "

ID	Function	Created date	Status	Owners	Not assigned since
1	IT	01-Dec	Issue Closed	Andy
2	HR	02-Dec	Issue opened	Charlie
3	HR	03-Dec	Issue opened	Charlie
4	SUM	04-Dec	Issue opened	Megan
5	Sales	05-Dec	Issue opened	Hoggard
6	Marketing	06-Dec	Issue opened	Owner not assigned	15 days
7	Marketing	07-Dec	Issue opened	Owner not assigned	14 days
8	Sales	08-Dec	Issue opened	Owner not assigned	13 days
9	IT	09-Dec	Issue Closed	Owner not assigned	12 days
10	HR	10-Dec	Issue opened	Owner not assigned	11 days
11	Finance	11-Dec	Issue opened	John
12	Finance	12-Dec	Issue Closed	John
13	Finance	13-Dec	Issue opened	Owner not assigned	9 days
14	Customer	14-Dec	Issue opened	Adam
15	Customer	15-Dec	Issue Closed	Adam
16	Customer	16-Dec	Issue opened	Tommy
17	Customer	17-Dec	Issue Closed	Tommy

[v-cherch-msft · Accepted solution]

Hi @ymirza

You may create a measure as below:

Measure =
IF (
    MAX ( Table1[Owners] ) = "Owner not assigned",
    DATEDIFF ( MAX ( Table1[Created date] ), TODAY (), DAY )
)

Regards,

Cherie

[ymirza]

Hi @v-cherch-msft, i tried your solution it is giving some values but only returing value 1, instead of actual difference of days. Plus it is hiding all the other rows where owners are assigned.

 

[v-cherch-msft]

Hi @ymirza

Remove .[Date] in your formula. Click the 'show items with no data' in the values filed.

Regards,

Cherie

[v-cherch-msft]

Hi @ymirza

Could you tell me if your problem has been solved? If it is,kindly mark the helpful answer as a solution and welcome to share your own solution. If not, please share more details about your issue so that we could help further on it.

Regards,

Cherie

[Greg_Deckler]

If not assigned since is a column, you can do this:

Not assigned since = DATEDIFF([Created Date],TODAY(),DAY)