Keeping column values when another field is blank

Question

Hello,&nbsp;I'm having a problem where Power BI is changing some of my column values to 'null' when there are actually numbers in the columns - it is doing this where other columns on that row are blank.&nbsp;Specifically I have campaign performance data, where some of the tracking fields are missing (these are blank) --&gt; this is causing the performance data on the same row to revert to 'null' when in fact there are still metrics I want to keep and count in my dashboard.&nbsp;Any suggestions on how to fix this would be much appreciated, thank you.

parry2k · Answer

Anonymous not sure why the value in a column will be changed to null if other columns are blank. Are you doing some transformation? Can you share some screen shot and more details on it.

anonymous · Answer

Of course, here's example screenshot so I know that the data exists but in Power BI they are changed to null:

In Power BIAs a CSV there are numbers in the metric columns

I haven't done any transformations, just used data source as csv here.

parry2k · Answer

Anonymous is it possible to share the csv file, remove any sensitive information you have. Also can you share what are your query steps are or copy power query code by clicking advanced editor

anonymous · Answer

Thanks,&nbsp;parry2k&nbsp;&nbsp;Uploaded a sample of the csv data source here https://ufile.io/2nzfh&nbsp;where columns C and D contain some blank fields that cause the following number columns to turn null in Power BI.&nbsp;Advanced editor contains (with some edits for sensitive information)letSource = Csv.Document(File.Contents("L:\FILELOCATION"),[Delimiter=",", Columns=14, Encoding=1252, QuoteStyle=QuoteStyle.None]),#"Promoted Headers" = Table.PromoteHeaders(Source, [PromoteAllScalars=true]),#"Changed Type" = Table.TransformColumnTypes(#"Promoted Headers",{{"dated", type datetime}, {"subject", type text}, removed a column for sensitity here (same as csv sample), {"utm_source2", type text}, {"utm_medium2", type text}, {"utm_campaign", type text},{"document_type", type text}, {"Actions taken", Int64.Type}, {"Action type 2", Int64.Type}, {"Action type 2", Int64.Type}, {"Actions taken all time", Int64.Type}, {"week", type date}, {"month", type date}, {"year", type date}})in#"Changed Type"&nbsp;Thanks in advance for taking a look

parry2k · Answer

Anonymous i just connected to csv file you provided and don't see any blank, pbix is attached.

Forum Discussion

Keeping column values when another field is blank

8 Replies

Related content

Sort by another column

Merge columns keep null

Find Most Recent Date Relative to another Date Column in Power Query

Yet another Sort by another Column error.

[PowerQuery] add (same) column from another table