Charley
Member
- Joined
- Jul 29, 2017
- Messages
- 64
- Reaction score
- 0
- Points
- 6
- Excel Version(s)
- 365
This line...
VAR ColumnOfMonths = DISTINCT(SELECTCOLUMNS(TableOfDays,"Months",Dates[Calendar Date for Months]))
...shows a squiggly red underline from SELECTCOLUMNS to the right.
However, Check Formula shows no error and COUNTROWS(ColumnOfMonths) returns the correct results.
Can anyone suggest what might be happening? Is the issue safe to ignore?
Thanks.
VAR ColumnOfMonths = DISTINCT(SELECTCOLUMNS(TableOfDays,"Months",Dates[Calendar Date for Months]))
...shows a squiggly red underline from SELECTCOLUMNS to the right.
However, Check Formula shows no error and COUNTROWS(ColumnOfMonths) returns the correct results.
Can anyone suggest what might be happening? Is the issue safe to ignore?
Thanks.