Forum Discussion

Ericwhv's avatar
Ericwhv
Icon for Helper II rankHelper II
3 years ago

Past 12 months Average

Hi All   I would like to work on some calutaion on past 12 month average of "Truck handle per HeadCount"   I have below existing formula Trucks per HC = DIVIDE([Number of Trucks],[Total HC]) ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi Ericwhv 

You can refer to the following sample

Sample data

 

Then create a measure

Measure = var a=SUMX(FILTER(ALL('Table'),OR('Table'[Year]=SELECTEDVALUE('Table'[Year])&&[Monthnum]<SELECTEDVALUE('Table'[Monthnum]),'Table'[Year]<SELECTEDVALUE('Table'[Year])&&[Monthnum]>=SELECTEDVALUE('Table'[Monthnum]))),[Trucks per HC])
return DIVIDE(a,12)

Output

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.