Power Query Multiply not Working

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.