Forum Discussion

BernardoPedroso's avatar
BernardoPedroso
New Member
7 years ago

Power BI- Convert SQL query to power bi

Basically i have to do on the power bi the same as the query that i do below.   selecT [Artigo] ,avg([uster]) AvgUster from (           selecT *, Rank()           over (Partition BY Artigo      ...
Need Help
v-yulgu-msft's avatar
v-yulgu-msft
Microsoft Employee
7 years ago

Hi BernardoPedroso,

 

You can create a calculated table in Power BI with below similar DAX formula:

New table =
VAR TOP5table =
    TOPN (
        5,
        FILTER ( FACT_Laboratorios, FACT_Laboratorios[Fornecedor] = "0013" ),
        FACT_Laboratorios[artigo], ASC,
        FACT_Laboratorios[data], DESC
    )
RETURN
    GROUPBY (
        TOP5table,
        [Artigo],
        "AvgUster", AVERAGEX ( CURRENTGROUP (), [uster] )
    )

Reference: 

TOPN
Nested grouping using GROUPBY VS SUMMARIZE

 

For more advice, please refer to this link to provide necessary sample data and expected result which can achieved by above SQL code.

 

Best regards,

Yuliana Gu