Asset Managment Dashboard

[eberg3]

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.

[Anonymous · Accepted solution]

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]

Perfect thank you, this helps a ton!