Forum Discussion
Zaky
Helper IV
Helper IVCount Specific Year Date in a column
Hi Experts, I would like to count a specific year date in a column. I'm using IF condition or statement to do that. Let says I want to see data for 2020, 2019 and the blank data. In this case i ...
Zaky , Try measures like
2020 = calculate(countrows('Data2020'), filter('Data2020', YEAR('Data2020'[Batch Return])=2020))
2019= calculate(countrows('Data2020'), filter('Data2020', YEAR('Data2020'[Batch Return])=2019))
amitchandak
Super User
Super UserZaky , Try measures like
2020 = calculate(countrows('Data2020'), filter('Data2020', YEAR('Data2020'[Batch Return])=2020))
2019= calculate(countrows('Data2020'), filter('Data2020', YEAR('Data2020'[Batch Return])=2019))
ZakyHelper IV
Helper IV