Forum Discussion
Rented items over time
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
Sounds like a variation on Open Tickets. https://community.powerbi.com/t5/Quick-Measures-Gallery/Open-Tickets/m-p/409364#M147
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.
3 Replies
Sounds like a variation on Open Tickets. https://community.powerbi.com/t5/Quick-Measures-Gallery/Open-Tickets/m-p/409364#M147
Greg_Deckler, thanks for youre advice!
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.
