Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I have a dataset which looks like the following:
I want to write a query that returns sales_week, product, username and the SUM of qty only where the SUM is greater than 1.
I would write this in SQL using a subquery as follows:
SELECT tbl1.* FROM (SELECT sales_week, username, product, SUM(qty) AS 'total_qty' FROM sales_data GROUP BY sales_week, username, product) AS tbl1 WHERE tbl1.total_qty > 1
Which would result in the following:
Can someone please help me to generate the same result in Power BI?
Solved! Go to Solution.
Hi @Anonymous
try this:
modeling -> create a newtable
New_table =
FILTER(
SUMMARIZE( Sales_data, 'Sales_data'[sales_week], 'Sales_data'[username], 'Sales_data'[product], "Total qty", sum('Sales_data'[qty])),
[total_qty] > 1)
Hi @Anonymous
try this:
modeling -> create a newtable
New_table =
FILTER(
SUMMARIZE( Sales_data, 'Sales_data'[sales_week], 'Sales_data'[username], 'Sales_data'[product], "Total qty", sum('Sales_data'[qty])),
[total_qty] > 1)
Thank you
Your provided solution worked like a charm!