Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Missing in set analisys

Hi guys,

I have missing value in Country variable.

How can fix this expression?

If(Len(Trim([Country]))>0,Count({<MYear={'$(=MonthName(max(MYear)))'}>}[Value]))

Thanks,

1 Solution

Accepted Solutions
Anonymous
Not applicable
Author

I found it.

Count({<MYear={'$(=MonthName(max(MYear)))'}>}If(Len(Trim([Country]))>0,[Value]))

Sorry.

View solution in original post

1 Reply
Anonymous
Not applicable
Author

I found it.

Count({<MYear={'$(=MonthName(max(MYear)))'}>}If(Len(Trim([Country]))>0,[Value]))

Sorry.