Question: 1/50
You import a CSV file into Power Query. Several numeric columns contain values like "1,234" and "2,500" (with commas) and are being treated as text. You need to ensure they load as whole numbers and aggregate correctly in visuals. What should you do?
Change the data type of the columns to Whole Number in Power Query
Create a DAX measure using VALUE() to convert the text to number at query time
In Report view, set the column summarization to Sum
Disable Auto date/time in Power BI Desktop