Forum Discussion
using calculate function
Hi All, Im new to power BI and i am having issue creating a DAX formula to achieve the result below Table 1 ID Description Location Remark From Date End Date 1234 Apple London ...
I think I see your point what you are trying to achieve but the logic is very incomplete. What if an item is returned mid year? Then it is counted as inventory in that year, but if it is returned on 31-12, it isn't? Where is that border, what if it is rented till 30-12? Why is there a line for available for Mango but not for the others?
My tip for you is: reconsider your datamodel and logic you want to apply, as this will become messy quickly.
My tip for you is: reconsider your datamodel and logic you want to apply, as this will become messy quickly.
Thanks for the tip JarroVGIT !
The from date and the end date in table 1 would be linked to a date table. With the date table, the date can be shown as Day, Months or Year.
Available implies that the item has been returned and is available to be rented out for the period between the start date till the end date