Rented items over time

[Ronald123]

Hello,

Can someone help me with the follow.

I need a line graph for each day of the year how many items are rented.

STOCK TABLE = actual stock for each item. Options = 0 (item rented) or 1 (item available)

TRANSACTION TABLE = [IN/OUT] Options = 1 = BACK IN STOCK  or -1 OUT OF STOCK

1030HALO1001 - ACTUAL STOCK = 1  (item available)

10-05-2020 > BACK IN STOCK

30-04-2020> OUT OF STOCK

In the line graph expected results dor each day between the dates:

30-04-2020 until 10-05-2020  > RESULT 1 (rented)
10-05-2020 until TODAY         > result 0 ( not rented)

Thank in advance,

Ronald

Test file 

[Greg_Deckler · Accepted solution]

Sounds like a variation on Open Tickets. https://community.powerbi.com/t5/Quick-Measures-Gallery/Open-Tickets/m-p/409364#M147

[v-diye-msft · Accepted solution]

Hi @Ronald123 

For how many items are rented. would you like to get below results:

(I added a new row as below to clarify if there's a book rented and backed at the same day, then the rentedcount at that day should be 0)

Pbix attached.

[Greg_Deckler · Accepted solution]

Sounds like a variation on Open Tickets. https://community.powerbi.com/t5/Quick-Measures-Gallery/Open-Tickets/m-p/409364#M147

[Ronald123]

@Greg_Deckler, thanks for youre advice!