GENERATESERIES DAX Function Not Incrementing Correctly

[SheldonEdwards]

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

[v-juanli-msft]

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]

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 · Accepted solution]

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