Forum Discussion
DAX Product() function
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
Wow, I've been experimenting with this and I can't make heads or tails of what the PRODUCT function is doing. I get some bizarre results such as infinity, etc. that make absolutely no sense what-so-ever. marcorusso do you have any idea what the PRODUCT function is doing here because it certainly does not seem like it is returning the PRODUCT of a column. I cannot make heads or tails of what it is actually doing.
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