Forum Discussion
Solved
Tracking active jobs
Hi all, I have data around jobs that are used on our systems, and I'd like to plot these out on a line graph, but I'd like to line graph to display when the various jobs started, and then also k...
Step 0: I use your data and a 'Calendar' data below.
Step 1: I edit 'DATA' table on Power Query Editor.
- After -
Step 2: I make a measure and a graph.
M_Active Jobs = CALCULATE(SUM([Active jobs 2]),FILTER(ALLSELECTED('Calendar'),'Calendar'[Date Time]<=MAX('Calendar'[Date Time])))
Step 0: I use your data and a 'Calendar' data below.
Step 1: I edit 'DATA' table on Power Query Editor.
- After -
Step 2: I make a measure and a graph.
M_Active Jobs = CALCULATE(SUM([Active jobs 2]),FILTER(ALLSELECTED('Calendar'),'Calendar'[Date Time]<=MAX('Calendar'[Date Time])))
This works perfectly - thanks