Power Query Multiply not Working

[MiguelNavarro]

Hi,

I have this issue where I get nulls (empty) in Multiply Columns in the table:

But, in the preview I do see the result and don't have this issue:

There are some rows that do work in the table, but mostly all are not working.

Have anyone else has had this issue before? 

Thanks!

[v-kpoloju-msft · Accepted solution]

Hi @MiguelNavarro,

Thank you for reaching out to the Microsoft Fabric Community Forum. Also, thanks to @Omid_Motamedise, @Greg_Deckler, for his inputs on this thread.

The issue you are seeing where your “Multiply Columns” step returns mostly nulls (even though the preview looks fine) usually happens when one or both columns aren’t truly numeric during load. Power Query sometimes shows correct results in preview because it auto-converts temporarily, but during refresh, the type mismatch causes nulls. Please follow the below steps those might be resolve the issue.

In Power Query, check both columns (Valor Contribution and Percentage) and make sure their data type is set to Decimal Number or Whole Number. Move your Changed Type step above the multiplication step. If your decimal values use commas, try converting using Data Type → Using Locale... and pick your regional setting. Reapply your custom column formula.

Refer to the below link:
https://learn.microsoft.com/en-us/power-query/data-types 

Hope this clears it up. Let us know if you have any doubts regarding this. We will be happy to help.

Thank you for using the Microsoft Fabric Community Forum.

[Omid_Motamedise]

Hi @MiguelNavarro 

It seems you don't share the same rows for Excel and Power Query. In Power Query, you won't see all the rows, just a preview of early ones, so it might happen in the next rows.

If it not an issue, it might be becuase of column format in excel sheets (like ;;;;) can you test and load it into another sheet and see the issue still available.

[Greg_Deckler]

@MiguelNavarro I notice that your columns are "any" (ABC123 in the column headers). Perhaps try switching them to whole or decimal numbers, 123, 1.2.