The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
I have a column "Process Step" with qualitative data, but there are many "null" values that prevent me from pivoting the column. I get errors I can't pivot cause of NA values or blank
I do NOT want to keep rows with nulls. I want to remove these rows entirely.
How can I edit the query and removet hese rows where null exists in a specific column?
Solved! Go to Solution.
@Anonymous
I think you can add a step in the PQ which is filtering that column
Proud to be a Super User!
@Anonymous
I think you can add a step in the PQ which is filtering that column
Proud to be a Super User!
@ryan_mayu wrote:@ryan_mayu
I think you can add a step in the PQ which is filtering that column
You can add a step to filter the column, but doing so doesn't appear to let me pivot still. I get "DataFormat.Error: Invalid cell value '#N/A'." when I try to pivot.
@Anonymous
could you please provide the sample data and the expected output?
Proud to be a Super User!
Filtering it did work actually. I was doing something wrong. Thanks!
User | Count |
---|---|
77 | |
77 | |
36 | |
30 | |
28 |
User | Count |
---|---|
106 | |
97 | |
55 | |
49 | |
46 |