Share via

Cannot convert a value of type Function to type Logical

Akhil Bansal 1 Reputation point
2022-12-01T10:14:01.773+00:00

"Filtered Rows" = Table.SelectRows(Source, if each Date.IsInCurrentMonth([Site RFS])=0 then each Date.IsInCurrentMonth([Site RFS])-1 else each Date.IsInCurrentMonth([Site RFS]) )

Expression.Error: We cannot convert a value of type Function to type Logical.
Details:
Value=Function
Type=Type

If I use the above code without the if statement then it is working. But I don't want to display blank data instead it should display previous months data
Any help would be appreciated.

Not Monitored
Not Monitored
Tag not monitored by Microsoft.
40,318 questions

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.