Forum Discussion

eberg3's avatar
eberg3
New Member
3 years ago
Solved

Asset Managment Dashboard

Hey Everyone,

 

I am trying to find a way to accurately and quickly display an assest managment dashboard for our company. Currently we use a simple Gantt Chart with an excel sheet driving the information, then refer to multiple other excel sheets to see how many assets are required for one day.

 

So we are wanting to use the information feeding the gantt chart which has a start and end date. Have this read a table which has the total quantity available and highlight any constraints. IE. Customer X will be renting Design 1 (which includes 3 Valves, 1 Cross) on April 3-12th, Customer Y will be renting Design 2 (which is 2 Valves and 2 Cross) on April 8-28th. We have only 4 valves and 2 crosses available in total. So the report would highlight that we will have a shortage April 8th to 12th due to insuffient assets.

Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi  eberg3 ,

    I created some data:

     

    Here are the steps you can follow：

    1. Create calculated table.

    Table 2 =
CALENDAR(
    DATE(2023,4,1),
    DATE(2023,4,30))

    2. Create measure.

    Cross_Remaining quantity =
var _all=2
return
4 -
SUMX(
    FILTER(ALL('Table'),
    'Table'[Date1]<=MAX('Table 2'[Date])&&'Table'[Date2]>=MAX('Table 2'[Date])),[Cross])
    Valve_Remaining quantity =
var _all=4
return
4 -
SUMX(
    FILTER(ALL('Table'),
    'Table'[Date1]<=MAX('Table 2'[Date])&&'Table'[Date2]>=MAX('Table 2'[Date])),[Valves])
    Measure =
IF(
    [Cross_Remaining quantity] <=0 || [Valve_Remaining quantity] <=0,
    "shortage","abundant")

    3. Result:

     

    Best Regards,

    Liu Yang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi  eberg3 ,

    I created some data:

     

    Here are the steps you can follow：

    1. Create calculated table.

    Table 2 =
CALENDAR(
    DATE(2023,4,1),
    DATE(2023,4,30))

    2. Create measure.

    Cross_Remaining quantity =
var _all=2
return
4 -
SUMX(
    FILTER(ALL('Table'),
    'Table'[Date1]<=MAX('Table 2'[Date])&&'Table'[Date2]>=MAX('Table 2'[Date])),[Cross])
    Valve_Remaining quantity =
var _all=4
return
4 -
SUMX(
    FILTER(ALL('Table'),
    'Table'[Date1]<=MAX('Table 2'[Date])&&'Table'[Date2]>=MAX('Table 2'[Date])),[Valves])
    Measure =
IF(
    [Cross_Remaining quantity] <=0 || [Valve_Remaining quantity] <=0,
    "shortage","abundant")

    3. Result:

     

    Best Regards,

    Liu Yang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

    • eberg3's avatar
      eberg3
      New Member
      3 years ago

      Perfect thank you, this helps a ton!