How to remove one semicolumn using DAX coding?

Hi toplisek,

Thank you for the clarification and you're right. Since DAX is designed for calculations after the data has been loaded into the model, it's not suitable for cleaning raw CSV files. Power Query (M) is indeed the right place to handle that kind of data transformation before it enters your model.

Instead of continuing to manually edit the raw files outside of Power BI, you can automate the process within Power Query. This way, the cleaning steps will consistently apply every time you refresh the data no more manual intervention needed.

For example, if your raw file has invalid values like Age = 0 or extreme outliers (e.g., Age > 120), you can use this simple Power Query snippet to correct them:

M Code:

= Table.TransformColumns(Source, {

    {"Age", each if _ = 0 or _ > 120 then null else _, Int64.Type}

})

This replaces invalid age entries with null, which you can later treat or exclude in your visuals.

If you're dealing with specific types of errors or patterns, feel free to share an example I'd be happy to provide a customized M script to match your scenario.

If this post helps, then please give us ‘Kudos’ and consider Accept it as a solution to help the other members find it more quickly.

Thank you for using Microsoft Community Forum.