Forum Discussion
tejapowerbi123
Helper V
Helper VNeed 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...
Try using Group By option inside Power Query.
Select column ID > choose Group by option > add these rules:
GilbertQ
Super User
Super UserHi there
What you can do is in Power Query to filter out rows they are blank.
Then when you bring this data into your dataset, it will automatically filter out blank values.
When you put this into a table it will display your final result.
What you can do is in Power Query to filter out rows they are blank.
Then when you bring this data into your dataset, it will automatically filter out blank values.
When you put this into a table it will display your final result.