Forum Discussion

Advocate I

8 years ago

Solved

GENERATESERIES DAX Function Not Incrementing Correctly

Hi All

Can anyone explain why this series goes out of kilter at around 0.685?

PBIX file here

https://drive.google.com/open?id=1wlL0trQVwiNZLDLLH0xB8cmBFfM_IEgS

Running PBI Desktop Version: 2.61.5192.601 64-bit (August 2018)

Thanks

SheldonEdwards
7 years ago
Hi v-juanli-msft

This looks like a known issue:
https://www.sqlbi.com/articles/generating-a-series-of-numbers-in-dax/

Looks like their suggested workaround works correctly:

Thanks

3 Replies

v-juanli-msft
Community Support
7 years ago
Hi SheldonEdwards

When testing in your pbix, I change your data type format as "Decimal number" instead of " General" as your original setting, it works well.

Best Regards

Maggie
- SheldonEdwards
  Advocate I
  7 years ago
  Thanks v-juanli-msft
  
  But I still get that problem, even when changing to decimal.
  
  If you increase the decimal places to maximum = 15, you will see the problem is still there. Yours was set to only 3 decimal places, so was maskingn the problem.
  
  This is what it looks like by the end of the series.
  
  I have updated my original PBIX file.
  
  Problem is not solved.
  Thanks
  - SheldonEdwards
    Advocate I
    7 years ago
    Hi v-juanli-msft
    
    This looks like a known issue:
    https://www.sqlbi.com/articles/generating-a-series-of-numbers-in-dax/
    
    Looks like their suggested workaround works correctly:
    
    Thanks

Related content