Forum Discussion

tejapowerbi123's avatar
tejapowerbi123
Helper V
6 years ago
Solved

Need help to data Clean

Hello Community, Can you please review below and provide your suggestion? I am not sure how to deal with below requirements. Thanks RAW DATA ID Province Budget A Ontario   A   20...
Need Help
  • nandic's avatar
    nandic
    6 years ago

    tejapowerbi123 ,

     

    Try using Group By option inside Power Query.
    Select column ID > choose Group by option > add these rules:

Anonymous's avatar
Anonymous
Not applicable
6 years ago

HI tejapowerbi123 

If you need the result in a visual.

Create two measures

_province = MAX([province]
_budget = MAX([budget]

and ID in the columns section of metrix

annd above created function in values.