Forum Discussion
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 info...
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
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
Perfect thank you, this helps a ton!
