Group by in PowerBi

+1 vote

Hi,

I have data as below

OrderID Product SubProduct SubProductValue ProductValue Above 100
1 A A 50 100 Yes
1 A B 25 100
1 A C 25 100
2 B A 10 20 No
2 B B 10 20

*Product Value has value added from sub product value column and put across in all rows.

How can I flag Yes or No based on addition of sub product value where value is >= 100

Aug 12, 2019 in Power BI by anonymous
• 230 points
643 views

1 answer to this question.

+1 vote
Hi,

One way is to create a column to group them, then follow the below procedure.

Above 100 Column = IF( SUM([ProductValue]) >= 100,"Yes","No")

The created field groups the rows into Yes or No depending on the condition.
answered Aug 12, 2019 by anonymous
• 33,030 points
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP