I hope to build a trend graph of running hours/mileage etc over time & have a tried a few ways in Dax from Sam’s lessons. But not quite at that level yet to know the Dax functions enough to filter this down.
Per the attached Pbix, I have multiple Components per Asset I need to filter out for each running hour. Each entry may be daily with some weekly or monthly, so need to find the previous entry according to the Asset & Component.
Would I be right in setting up a number of measures to filter first, then subtract Today from Earlier? I have this in another Data model, with Assets as a Lookup table also if that matters.
Similar to vehicle miles or temperature entries to show a trend of utilisation.
Running Hours.pbix (41.3 KB)