Forum Discussion
Count measure for specific years
Hi, I want to count all the days in my data for the year 2019. How can I filter to only those days with a measure? I came up with something like this: Measure = COUNTAX(FILTER(Date_Table, Dat...
Good afternoon dear.
Do you want to count the amount of data that has a date in the year 2019?
If so, I advise you this DAX
CountRows = COUNTROWS ( FILTER ( 'Table', 'Table'[Column1].[ Year] = 2019) )
Good afternoon dear.
Do you want to count the amount of data that has a date in the year 2019?
If so, I advise you this DAX
CountRows =
COUNTROWS (
FILTER ( 'Table', 'Table'[Column1].[ Year] = 2019)
)Syndicate_Admin Perfect, thanks!
Please accept it as a solution so that other people who have the same question can find it faster.
Thank you.