cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

New Member

## Rounddown

I have set up a table in PBI.  I need to add a column (right click New column) with the following excel command =Rounddown((B2*1.15),0)  I have replaced the B2 with the column name being Wkstn (should be count of wkstn but that didn't come up as an option)  so on the line I now have:

1 Capacity at 1:15 flex rate = ROUNDDOWN(([Wkstn]*1.15),0)

I come up with the error Cannot convert '1-S-58' of tpe Text to type Number.

I have no idea what this means or where I have gone wrong, would someone please advise?  I am very new to PBI.

Thank you so much!!

1 ACCEPTED SOLUTION
Super User

@dstout Would have to see some sample data. Do you mean like:

ROUNDDOWN((COUNT([Wkstn])*1.15),0)

Become an expert!: Enterprise DNA
External Tools: MSHGQM
Latest book!:
Power BI Cookbook Third Edition (Color)

DAX is easy, CALCULATE makes DAX hard...
4 REPLIES 4
Super User

@dstout It means your [Wkstn] column is text and not numeric.

Become an expert!: Enterprise DNA
External Tools: MSHGQM
Latest book!:
Power BI Cookbook Third Edition (Color)

DAX is easy, CALCULATE makes DAX hard...
New Member

Thank you Greg.  Okay so the wkstn heading is in text but the details are the count of the wkstn's so they are numerical.  Do you know how I may be overcome this?

Thank you again

Super User

@dstout Would have to see some sample data. Do you mean like:

ROUNDDOWN((COUNT([Wkstn])*1.15),0)

Become an expert!: Enterprise DNA
External Tools: MSHGQM
Latest book!:
Power BI Cookbook Third Edition (Color)

DAX is easy, CALCULATE makes DAX hard...
New Member

Fixed, thank you!!

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.