Forum Discussion
markus_zhang
Advocate III
Advocate IIIHow to filter out blank rows from a column
Hi experts, I'm trying to use a calculate column to get the percentile based on another column that has blank values, Power BI complains that "Expressions that yield variant data-type cannot be used...
Solved.
I stumbled on another post and solved the issue by changing the format of the source column to decimal instead of integer. Apparently this has nothing to do blank values, as my other percentile calculated columns also consume balnk values and they are fine.
markus_zhangAdvocate III
Advocate IIISolved.
I stumbled on another post and solved the issue by changing the format of the source column to decimal instead of integer. Apparently this has nothing to do blank values, as my other percentile calculated columns also consume balnk values and they are fine.