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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
OlgaUA
Frequent Visitor

How to create a simple new table with two columns: ID (count) and value?

I can not find formulas, descriptions ..
Is it really only an import?

Thank you

1 ACCEPTED SOLUTION
v-ljerr-msft
Microsoft Employee
Microsoft Employee

Hi @OlgaUA,

 

Both solutions provided above can create a simple new table in your scenario.Smiley Happy

 

1. Click Get Data -> Choose Blank Query, then Enter the formula below.

=#table({"ID","Value"},{{1,"A"},{2,"B"}})

2. Click "Enter Data" under Home tab, then you should be able to input/paste your table there.

 

Regards

View solution in original post

5 REPLIES 5
v-ljerr-msft
Microsoft Employee
Microsoft Employee

Hi @OlgaUA,

 

Both solutions provided above can create a simple new table in your scenario.Smiley Happy

 

1. Click Get Data -> Choose Blank Query, then Enter the formula below.

=#table({"ID","Value"},{{1,"A"},{2,"B"}})

2. Click "Enter Data" under Home tab, then you should be able to input/paste your table there.

 

Regards

Hello, everybody,

Thank you very much, everything turned out

Hi @OlgaUA,

 

Great to hear the problem got resolved! Could you accept helpful replies as solution to help others who may also have the similar issue easily find the answer and close this thread?Smiley Happy

 

Regards

Vvelarde
Community Champion
Community Champion

@OlgaUA

 

Hi, you can create a new table using "Enter DATA" Option.

 

 




Lima - Peru
hugoberry
Responsive Resident
Responsive Resident

In Query Edit try

 

=#table({"ID","Value"},{{1,"A"},{2,"B"}})

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

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

July PBI25 Carousel

Power BI Monthly Update - July 2025

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