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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
dstout
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

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

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


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

View solution in original post

4 REPLIES 4
Greg_Deckler
Super User
Super User

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


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

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

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

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


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

Fixed, thank you!!

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors