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.

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

Hi LeaRupnik ,

If  you want to import the data, you could try add the code into "SQL statement" while connecting SQL Server.

If you want to create a new table, you could try the function of SUMMARIZE. Here are some blogs that you can learn from.

best practices using summarize and addcolumns 

Joining tables in Power BI with Power Query and DAX

side effects in dax of the sort by column setting

 

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