Forum Discussion
Solved
If statement to return a numeric value if column contains any value.
This is what I used
Beginner here
My formula works : Count of Activity = IF(ISBLANK('Distribution'[ Activity]),"","1")
But it returns a text vaule and I need it to be a numeric value, because I need to count them in a table by activity.
Changing the Data type causes an error
Please help
Try returning a number instead of a text.
Count of Activity = IF(ISBLANK('Distribution'[ Activity]),BLANK(),1)
1 Reply
- AlexisOlson
Super User
Try returning a number instead of a text.
Count of Activity = IF(ISBLANK('Distribution'[ Activity]),BLANK(),1)