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:

nandic's avatar
nandic
Resident Rockstar
6 years ago

tejapowerbi123 ,

 

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