Forum Discussion

SheldonEdwards's avatar
SheldonEdwards
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 Deskt...
Need Help
v-juanli-msft's avatar
v-juanli-msft
Community Support
8 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's avatar
SheldonEdwards
Advocate I
8 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