Forum Discussion
Measure rounded to 0 decimals in DirectQuery
UPDATE
I found the issue, is the new Snowflake connector 2.0 (https://learn.microsoft.com/en-us/power-query/connectors/snowflake#new-snowflake-connector-implementation-preview), i'd the connection the next way:
Source = Snowflake.Databases(database, Warehouse, [Implementation="2.0"])
I removed this part [Implementation="2.0"] to use the previous connector and then it works OK.
Hi Anonymous ,
Please use the below measure to achieve the desirable output.
15.2 Valor Mercado Contravalorado =
ROUND(SUM(FACT_SCR_TIPO_CAMBIO[VALOR_MERCADO_KONTRAV]), 2)
If the issue is still unresolved, check the column-level formatting for VALOR_MERCADO_KONTRAV in your data model:
-
Is it defined as
Fixed Decimal NumberorWhole Numberin Snowflake? -
Sometimes, DirectQuery doesn't recognize precision unless explicitly defined in the source.
🌟 I hope this solution helps you unlock your Power BI potential! If you found it helpful, click 'Mark as Solution' to guide others toward the answers they need.
💡 Love the effort? Drop the kudos! Your appreciation fuels community spirit and innovation.
🎖 As a proud SuperUser and Microsoft Partner, we’re here to empower your data journey and the Power BI Community at large.
🔗 Curious to explore more? [Discover here].
Let’s keep building smarter solutions together!