Forum Discussion

LeaRupnik's avatar
LeaRupnik
Helper III
6 years ago
Solved

how to create temp table with same sample like table on base

Hello.  A have a one problem in SQL i now how to solve the case, bat in power bi i a new.  I hawe a sql statment how to this do in power bi:    WITH TEMP (PARENT_ID, ID, i) AS -- tempory table (...
Need Help
  • v-xuding-msft's avatar
    v-xuding-msft
    6 years ago

    Hi LeaRupnik ,

    Does that make sense? If so, kindly mark my answer as the solution to close the case please. More people will benefit from here. Thanks in advance.

     

    Best Regards,

    Xue Ding

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

LeaRupnik's avatar
LeaRupnik
Helper III
6 years ago

Hello. 

i woud like to do tempory table in PowerBi.  At first i greate tem table 

 

Temp1 = DISTINCT(SELECTCOLUMNS(ORGANIZACIJA;"PARENT_ID";ORGANIZACIJA[PARENT_ID];"ID";ORGANIZACIJA[ID];"i";1))

 

Now i woud luke to ask how in do tempory table include where function from another table like

 

PROGENOT IN (SELECT DISTINCT PROGENOT FROM DW.PAKIRANO)

 

 

Thanks. 

LP

LEa

v-xuding-msft's avatar
v-xuding-msft
Community Support
6 years ago

Hi LeaRupnik ,

Sorry for late back. You could use CALCULATETABLE function or  FILTER function to add filter conditions like "where" in SQL.

Table 2 = CALCULATETABLE (VALUES('Table'[Country]),'Table'[Product] = "Paseo" )

 

Reference:

https://www.sqlbi.com/articles/filter-vs-calculatetable-optimization-using-cardinality-estimation/

 

Best Regards,

Xue Ding

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.