Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Learn more

Reply
Kerk
Frequent Visitor

GENERATESERIES using 0.01 increments

Hello everyone,

 

I am creating a table, which I will use to reference duration down to milliseconds.

For this reason I am using 

 

Time = GENERATESERIES(0.01,1800,0.01)

 

Eveything seems ok until it gets to number 0.81, following that numbers start getting ugly and I see no reason for this happening:

 

 

PowerBI.png

 

Am I missing something or looks like a bug?

Any ideas?

Thanks 

1 ACCEPTED SOLUTION
rohit_singh
Solution Sage
Solution Sage

Hi @Kerk 

Please change the number of decimal places from "Auto" to 2.

rohit_singh_0-1652960320598.png

Kind regards,

Rohit


Please mark this answer as the solution if it resolves your issue.
Appreciate your kudos😊

View solution in original post

3 REPLIES 3
rohit_singh
Solution Sage
Solution Sage

Hi @Kerk 

Please change the number of decimal places from "Auto" to 2.

rohit_singh_0-1652960320598.png

Kind regards,

Rohit


Please mark this answer as the solution if it resolves your issue.
Appreciate your kudos😊

Thank you for getting back to me. Rounding workaround does the job, however I am concerned somethings is wrong with my installation.

NickolajJessen
Solution Sage
Solution Sage

Lol, that's weird.
This work?

GenerateSeries = GENERATESERIES(0.01,1800,round(0.01,2))

Or
format column with only 2 decimals?
NickolajJessen_0-1652960324120.png

 

Helpful resources

Announcements
Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors