Forum Discussion
Measure rounded to 0 decimals in DirectQuery
Hello, I have a hybrid dataset connected to Snowflake via DirectQuery for Fact tables and import for dimension tables. I've created a measure with SUM, but when i visualize it the decimals are roun...
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.
anilelmastasi
Super User
Super UserHello Anonymous ,
You can create a new measure, like this= ROUND(SUM('FactTable'[Amount]), 2)
Or you can multiply with "1.0"
If this solved your issue, please mark it as the accepted solution. ✅