Forum Discussion

Mic1979's avatar
Mic1979
Icon for Post Partisan rankPost Partisan
1 year ago
Solved

Dynamic Expand Power Query Custom Function

Dear all,   I have two tables to merge. Here two samples table: Table_to_Change   and  Start_Table (this table as other columns that the ones represented here...) What I need is t...
Need Help
  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi Mic1979  ,
    Thanks for reaching out to the Microsoft fabric community forum.

    There may be a possibility that you are encountering data type mismatch, consider changing the data type from percentage to decimal number and then multiplying them and check if you are still encountering the issue.

    Also consider using error handling  https://learn.microsoft.com/en-us/power-query/error-handling
    to test and catch errors in your code.



    If you find this post helpful, please mark it as an "Accept as Solution" and consider giving a KUDOS.
    Thanks and Regards

Mic1979's avatar
Mic1979
Icon for Post Partisan rankPost Partisan
1 year ago

Dear all,

any feedback on the last post?

Thanks a lot

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi Mic1979  ,
Thanks for reaching out to the Microsoft fabric community forum.

There may be a possibility that you are encountering data type mismatch, consider changing the data type from percentage to decimal number and then multiplying them and check if you are still encountering the issue.

Also consider using error handling  https://learn.microsoft.com/en-us/power-query/error-handling
to test and catch errors in your code.



If you find this post helpful, please mark it as an "Accept as Solution" and consider giving a KUDOS.
Thanks and Regards