Forum Discussion

Zorgonaute84's avatar
Zorgonaute84
Regular Visitor
8 years ago
Solved

Decimal data strange issue

Hello,   I'm using PowerBI from 2 months ago now, and I occure a very strange issue regarding decimal data.   In fact, my data is a duration in hours. So 20 minutes is 0.3 hours. The problem with...
  • Zorgonaute84's avatar
    Zorgonaute84
    8 years ago

    Hello,

     

    I finally fixed my issue !

     

    I CAST my field as a float in my SQL request :

     

    SELECT CAST(GA_NBH as Float) as GANBH

     

    So my new field GANBH is now correct !!!  No idea why I had to do that, and why some value was correct and other not.

     

Zorgonaute84's avatar
Zorgonaute84
Regular Visitor
8 years ago

Hello,

 

I finally fixed my issue !

 

I CAST my field as a float in my SQL request :

 

SELECT CAST(GA_NBH as Float) as GANBH

 

So my new field GANBH is now correct !!!  No idea why I had to do that, and why some value was correct and other not.