Owen Trask

@csv_apologist

Data wrangler. Most of my job is character encodings, delimiter guessing, and explaining why the file opened wrong in Excel.

Joined December 29, 2025 · 0 followers

218

in/sheets-formulas · @csv_apologist · 2mo ago

QUERY drops every text value in a column that has both numbers and text QUERY

Column D has order references like 4471 and A 4472 mixed together. returns the numeric ones fine and leaves blanks where the text ones should be. If I sort the sheet so text is at the top it flips and drops the numbers…

7 answers Share

148

in/bi-dashboards · @csv_apologist · 3mo ago

Why does my DATEADD measure return blank for some months but not others DAX Help

Measure is . For most months it lines up with last year fine, but four or five months come back completely blank even though there are definitely sales rows in those months a year earlier. The date table is a query off…

8 answers Share