Forum Discussion

MojoGene's avatar
MojoGene
Post Patron
8 years ago

Null 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...
Need Help
Greg_Deckler's avatar
Greg_Deckler
Community Champion
8 years ago

What is it's data type?

  • MojoGene's avatar
    MojoGene
    Post Patron
    8 years ago

    I 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.