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 & Attrition % = SUMMARIZE(Append1,Append1[Reporting Month],"Total HC",[Total EMP],"Total Attrition",[Attrition])
Solved! Go to Solution.
I have tried. it is throwing the following error
DAX comparison operations do not support comparing values of type Integer with values of type Text. Consider using the VALUE or FORMAT function to convert one of the values.
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 ) ) )
Visit our Community Blog for articles, guides, and information created by fellow community members.
Need help with the Power BI Community? Our 'Using the Community' support articles are a great place to start.
Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications
Features releasing from October 2020 through March 2021