cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
croberts21
Post Patron
Post Patron

How to make Table of fixed values

SUPERCEDED BY A NEW QUESTION. Please ignore this question.

 

I have Free PBI Desktop v2.102.845 (64 bit free version Feb 2022) on Windows 10. I use an ODBC driver to connect to a Postgresql database server.

 

I need to make a table of fixed values. The columns are: Payrollcode (a number) and ShortDesc (a short description of the payroll code which will be displayed to the user), LongDesc (a longer description). Some example values: 

1REGRegular time
2OTOvertime
3DBLDouble time

 

The database stores the codes, but I want my report to show the short description. I've been searching for videos on this and have not found one yet. Most videos are about creating a table with a calculated column. I don't want a calculated column, my columns will all be entered manually and will not change based on data in another table.

 

On the Data tab (far left) I have clicked New Table then entered this command:

#table(
//column headers
{"Payrollcode","ShortDesc","LongDesc"},
//row content
{
{"1","REG","Regular time"},
{"2","OT","Over time"},
{"3","DBL","Double time"}
}
)

 

But I get the error "To use special characters in a calculated table name, enclose the entire name in brackers ([]) and add a ] to any closing brackets in the name."

 

Thank you!

1 ACCEPTED SOLUTION

I think I found something. I found on the Viz tab (far left), Home tab bar, there is Enter Data. I will try that.

View solution in original post

4 REPLIES 4
PaulDBrown
Super User
Super User

Can you post a sample PBIX file or sample data?





Did I answer your question? Mark my post as a solution!
In doing so, you are also helping me. Thank you!

Proud to be a Super User!
Paul on Linkedin.






I think I found something. I found on the Viz tab (far left), Home tab bar, there is Enter Data. I will try that.

How do I post a PBIX file here? All forums are different and I don't see a way to attach a file to a reply.

You can upload it to a cloud service (OneDrive, Google Drive, Icloud...) and share the download link to file from there





Did I answer your question? Mark my post as a solution!
In doing so, you are also helping me. Thank you!

Proud to be a Super User!
Paul on Linkedin.






Helpful resources

Announcements
August 2022 update 768x460.jpg

Check it Out!

Click here to learn more about the August 2022 updates!

August 1 episode 9_no_dates 768x460.jpg

The Power BI Community Show

Watch the playback when Priya Sathy and Charles Webb discuss Datamarts! Kelly also shares Power BI Community updates.

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Top Solution Authors
Top Kudoed Authors