Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hey All,
I was watching this great lesson , "
and at around the 29th minute of the video, the presenter shared a code for user-defined types as below :
let
CustomerRecordType = type [FirstName=text, LastName=text],
CustomerTableType = type table customerRecordType,
CustomersTable=
#table (CustomerTableType,{
{"Matt", "Masson" },
{"chris", "webb" },
{"Reza", "Rad" },
{"Chuck", "sterilicious"}
}
)
in
CustomersTable
But when I am running the code in PQ, verbatim as shared, I get the following error :
Any idea why I am getting this error instead of the table and shown in the output in the lesson? Am I missing something?
Thanks and really appreciate the help.
Solved! Go to Solution.
PQ is super sensitive to case. This line has customerRecordType which should have been CustomerRecordType (i.e. small case c should be replaced with C).
CustomerTableType = type table customerRecordType
Hence, if your change it to following, then this would work
CustomerTableType = type table CustomerRecordType
PQ is super sensitive to case. This line has customerRecordType which should have been CustomerRecordType (i.e. small case c should be replaced with C).
CustomerTableType = type table customerRecordType
Hence, if your change it to following, then this would work
CustomerTableType = type table CustomerRecordType
User | Count |
---|---|
8 | |
7 | |
5 | |
5 | |
4 |
User | Count |
---|---|
14 | |
13 | |
8 | |
6 | |
6 |