Forum Discussion

D3nnisd's avatar
D3nnisd
Frequent Visitor
7 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
    7 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
7 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.

marcorusso's avatar
marcorusso
Most Valuable Professional
7 years ago

Yes, decimal is a float and whole number is an integer.

I don't know why there is this bug - I just imagined that PRODUCT is a function designed to work with decimal numbers because you usually use it to compute compound interests. However, it should work with integers too - Microsoft should answer for that, I would say it's a bug.

 

Marco Russo - SQLBI