Forum Discussion
Solved
Summarize Table to retrieve 2017 data
Hi, I have created Table using summarize function. however, I want to restrict the data of 2017 only. Can you please help to retrieve only 2017 data. I have written the following measure. HC ...
You Rock Zubair. A ton thanks for you. It is working fine
HI sureshcu
Try this
HC & Attrition % =
FILTER (
SUMMARIZE (
Append1,
Append1[Reporting Month],
"Total HC", [Total EMP],
"Total Attrition", [Attrition]
),
OR (
YEAR ( Append1[Reporting Month] ) = 2017,
AND (
YEAR ( Append1[Reporting Month] ) = 2016,
MONTH ( Append1[Reporting Month] ) = 12
)
)
)You Rock Zubair. A ton thanks for you. It is working fine