Forum Discussion

granthworth's avatar
granthworth
Icon for Kudo Kingpin rankKudo Kingpin
10 years ago
Solved

DAX issue with Date data type

I am having an issue today with a DAX formula.   The scenario is as follows. I have 2 Power BI desktop files which are formatted identically. I have them linked to separate Excel workbooks which ar...
  • granthworth's avatar
    granthworth
    10 years ago

    Thanks for the input everyone.

     

    However, after going through my source data, I found the following string of typos in the date column. Correcting them also corrected this issue.

     

    381	1/19/16
382	1/19/16
383	1/19/16
384	1/19/16
385	1/19/16
386	1/19/16
387	01/119
388	01/119
389	01/119
390	01/119

    I have adjusted the data validation and formatting restrictions to the user form through which this data is input.

     

    Thanks again for helping with my case of the Mondays.

     

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
10 years ago
I'm guessing that in your second sheet that your [Date] column is not tagged as a datetime type, but rather a text type. Could be a regional issue where months and days are flipped.