Measure Help, PowerPivot

[Craigc3814]

I did not realize Power Pivot had been added back to Microsoft Office, thank you to Power Geek for pointing that out!!

I have 2 tables of data I cleaned with PQ one that looks into a network folder and creates an average of 12 different columns of data that I have. There are approx. 300 rows of data that are identified by the name of the asset. The columns involve how many times something within an asset started and then a column for how long it ran. Each asset has 6 components so 12 total columns of data there starts and runtime for each component.

I then have another table that goes in and looks at only the most recent file within the folder.

What I want to do is look and see which asset components are starting longer than usual, or running longer than usual. So really just a 1 to 1 comparison by asset from the most recent file to the average file.

If an asset started or ran way more than average it is usually a good indicator that the asset need maintenance.

I am very comfortable writing Excel formulas but DAX is brand new to me, I have only learned M to this point.

Basically I want an If formula that says if Asset Component 1 has ran more today than average flag it, if Asset Component 1 runtime is larger than average flag it. So on and So on.

Any help is greatly appreciated.

 

[VBA Geek]

Hello, for a faster reply you are gonna need to share some source data