Forum Discussion

D3nnisd's avatar
D3nnisd
Frequent Visitor
8 years ago
Solved

DAX Product() function

Hi,   I'm a IT student currently self learning DAX as part of my upcomming internship.  I am using this guide to learn and Contoso Sales sample for this part.  So far its fairly straight forward, u...
  • marcorusso's avatar
    marcorusso
    8 years ago

    The Channel column is defined as Whole Number, it should be a Decimal - do that and it returns 24.

    That said - it's funny how it behave with an integer! I suggest submitting the issue to Microsoft.

     

    Marco Russo - SQLBI

marcorusso's avatar
marcorusso
Icon for Most Valuable Professional rankMost Valuable Professional
8 years ago

The Channel column is defined as Whole Number, it should be a Decimal - do that and it returns 24.

That said - it's funny how it behave with an integer! I suggest submitting the issue to Microsoft.

 

Marco Russo - SQLBI

D3nnisd's avatar
D3nnisd
Frequent Visitor
8 years ago

Thanks marcorusso ,  Greg_Deckler and Anonymous for replying!

 

Changing it to a decimal did the trick.

This raises 2 questions:

 

- Where is that 0.79 comming from?

- What is the absolute diffrence between a whole number and a decimal. Can the decimal be seen as a float and a whole number as a integer?  But this still doesnt explain where the 0.79 come from.

 

I will report the issue to Microsoft.