Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to Solution.
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.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
97 | |
96 | |
81 | |
74 | |
66 |
User | Count |
---|---|
126 | |
106 | |
105 | |
86 | |
72 |