Can't find source for a calculated table in tabular model

Question

I am reviewing a Cube, and I have table named WIPs, which is a calculated table with code: FILTER ( DATATABLE("WIP's" , STRING , {{}}) , 0 )

I have a few questions:

I am wondering if its auto-referencing and because TableName field doesn’t admit the caracter: ‘ it gets removed?!

If its not auto-referencing, then ;WIPs table points to WIP’s … I am unable to find this WIP’s table… (it’s not in the model or at source…)

I also do not understand what the code is doing? What is {{}}?

Any clarification will be appreciated.

Answer 1

Hi,

The "WIP's " is the column name in the created table, not the table name. You would have your table name when you input the dax expression.

So I am guessing your full expression need to be

WIP's = FILTER ( DATATABLE("WIP's" , STRING , {{}}) , 0 )  

The {{}} is the content in of the column in created table. In you case, it is an empty string.

You could understand it more clearly if you try similar :

Try to see the results of :

TestTable= DataTable("Name", STRING,    
               "Region", STRING    
               ,{    
                        {" User1","East"},    
                        {" User2","East"},    
                        {" User3","West"},    
                        {" User4","West"},    
                        {" User4","East"}    
                }    
           )    

See reference here : DATATABLE

---

If the answer is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
What can I do if my transaction log is full?--- Hot issues November
How to convert Profiler trace into a SQL Server table -- Hot issues November