Welcome to OStack Knowledge Sharing Community for programmer and developer-Open, Learning and Share
Welcome To Ask or Share your Answers For Others

Categories

0 votes
933 views
in Technique[技术] by (71.8m points)

powerbi - DAX create empty table with specific column names and no rows

How to create a table with a specified column name and no rows at all. The following oneliner does what I want but shows error message that there should be second argument in ROW function.

EmptyTable = ROW ("Product")

I would like to use it for making bridge tables with desired column name. For example I want Product_bridge table to have a column "Product".

Product_bridge = DISTINCT(
    UNION(
         DISTINCT(      Sales[Prod_Name]        ) 
        ,DISTINCT( Dictionary[Prod_DifferntName])
        ,DISTINCT(  PriceList[P]                )
        ))

The code above gets me the name of the first table, in this case Prod_Name.

See Question&Answers more detail:os

与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
Welcome To Ask or Share your Answers For Others

1 Answer

0 votes
by (71.8m points)

You could just filter it. Or select TOPN 0.

TOPN:

Table = TOPN(0;DATATABLE("Product";STRING;{{}}))

FILTER:

Table = FILTER(DATATABLE("Product";STRING;{{}});0)

与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
Welcome to OStack Knowledge Sharing Community for programmer and developer-Open, Learning and Share
Click Here to Ask a Question

2.1m questions

2.1m answers

60 comments

57.0k users

...