Forum Discussion

BBesler's avatar
BBesler
Regular Visitor
2 years ago
Solved

Dynamic view to inventory

Hello,

I want to create a table or visual, where I can see the stored machines per day.

Therefore a have one table with 3 rows (Ordernbr, Booking date into the storage, Booking date out of the storage).
Every line is a mashine.

What I need is a table with the numbers of machines per day. 
I tried to calculate the values by using filters, what does not work.

Any idea, how to solve the problem?

Regards
Benno

 



Need Help

4 Replies

  • SamWiseOwl's avatar
    SamWiseOwl
    Super User
    2 years ago

    Hi BBesler 

    Create yourself a calendar table, there is a blog how to do it here: https://www.wiseowl.co.uk/blog/s2947/calendarauto-table.htm

     

    Join this onto your In booking column.

     

    Put the day column in a visual and then create a measure:
    Computers out =
    var currentDay = selectedValue(calendartable[date])

    Return
    Calculate(
    Count(table[Ordernbr]), Filter(AllSelected(table), [In Booking] <=currentDay && [Out Booking] >= currentDay))

    • BBesler's avatar
      BBesler
      Regular Visitor
      2 years ago

      Hello,

      the measure works, but I have still not the correct results.
      I joined the new data table with the in booking column.
      This effects that the result is related to the in bookong column. The x-axis is the date of the new date table.
      So the result is related to the in booking date.

      What I need is the sum of machines per day. 
      If I use the in booking day, the result is not the total sum for this day, because there a mashines with a earlier in booking day, which are still on stock. 

      The logic is correct. 
      1. InBookingDate <= CurrentDate
      AND
      2. OutBooking Date >= CurrentDate

      But If I use the InBookingDate the measure does not count all mashines which are in stock for the CurrentDay.

      Any idea?