
Explanation:
Box 1: No
It will show the total number of accounts that were live at the last day of the year only.
Note:
DISTINCTCOUNT counts the number of distinct values in a column.
LASTDATE returns the last date in the current context for the specified column of dates.
Box 2: No
It will show the total number of accounts that were live at the last day of the month only.
Box 3: Yes
Reference:
https://docs.microsoft.com/en-us/dax/distinctcount-function-dax https://docs.microsoft.com/en- us/dax/lastdate-function-dax