Forum Discussion
MojoGene
Post Patron
Post PatronNull Values Imported from Excel
I have a fully qualified date table to which I have added a column that contains a decimal number representing the year fraction. The Excel formula takes an existing "DayOfYear" column and divides b...
Greg_Deckler
Community Champion
Community ChampionWhat is it's data type?
MojoGenePost Patron
Post PatronI switched the data type around and tried everything including text. Nada. I finally deleted the column in the Excel spreadsheet and added a calculated column to the spreadsheet in the PBI Query Editor, which is working.