How to make use of DAX or PQ to add new table to my existing PBI file ?

[admin11]

Hi All

I need to add below table into my existing PBI file.

NUMBER_OF_STAFF Table :-

SOURCE_NEW......NUMBER_OF_STAFF

A................................10

B................................100

C................................1000

D................................10000

May i know what is the fast way ?

And i am allow the change the number of staff manually.

Don't use import the above Table by sharepoint folder load.

Make use of PQ or DAX.

My PBI file :-

https://www.dropbox.com/s/2kdpck4yzh418r1/PBT_V2021_396%20TI_SI_GL%20SAMPLE.pbix?dl=0

Paul Yeo

[Jihwan_Kim · Accepted solution]

Hi, @admin11 

Please correct me if I wrongly understood your question.

When I need to create tables without importing them, I generally use EnterData.

Here, you can type in by yourself, or you can copy a table from Excel and paste it here, or if you want to amend this, then you can go to Power Query and amend it.

Hi, My name is Jihwan Kim.

If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.