Forum Discussion

SP7273's avatar
SP7273
Regular Visitor
3 years ago

Hide / remove rows based on criteria

Only new to this and have bitten off more that I can chew. I have a large amount of data and need to clean it up by hiding / removing row that are not relevant to the outcome. In the screen shot be...
Need Help
SP7273's avatar
SP7273
Regular Visitor
3 years ago

Thanks Edhans for the information and you're time.

I will look into this today and see if I can get it working.

one question will the date format be a issue? using Australian format.

edhans's avatar
edhans
Icon for Community Champion rankCommunity Champion
3 years ago

No. The core code should work fine when you localize it on your machine. My sample code may not work for the date type though. You would need to change the Change Type step in my code to this:

= Table.TransformColumnTypes(#"Changed Type with Locale",{{"Score", Currency.Type}, {"Date", type date}}, "en-US")

 

Or redo the dates in your local format first.