Forum Discussion
Solved
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 (...
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.
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!