需求：在projectID為4的基礎(chǔ)上查找最新的一天花沉，從而計算duration的總和
test result for latest date = FORMAT(
CALCULATE(SUM('table'[duration]),
FILTER(
ALLSELECTED('table'),
'table'[date] =
MAXX(
filter(
ALLSELECTED('table'),'table'[projectID] = 4
),
'table'[date]
)
)
),"Long Time")
