Forum Discussion
SheldonEdwards
8 years agoAdvocate I
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 Deskt...
- 8 years ago
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
SheldonEdwards
8 years agoAdvocate I
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
8 years agoAdvocate I
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