Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
order by artigo asc, data desc) AS Rank_
FROM [Mundifios_DW].[dbo].[FACT_Laboratorios] b
where Fornecedor = '0013' --- Condições da query
) rs
where RANK_ <=5
group by [Artigo]
GO
I cannot understand the steps that i have to do to sucefully do that query on the power bi report that im doing. Can you please help me?
Best Regards
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
When you connect to your SQL database in the Query Editor, use "Advanced" and just paste in your SQL.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
106 | |
93 | |
75 | |
62 | |
50 |
User | Count |
---|---|
147 | |
107 | |
105 | |
87 | |
61 |