Forum Discussion

cocomy's avatar
cocomy
Icon for Resolver I rankResolver I
8 years ago
Solved

Data type : Date Format : dd-mmm-yy

Hi All,   Suddenly,  date format : dd-mmm-yy dissapered.   I removed power BI and download again but it only gives me Japanese or yyy-mmm-dd selections.   Could you please help me how to return...
Need Help
  • rocky09's avatar
    rocky09
    8 years ago

    did you checked the column in Query Editor? What date format it has? cocomy

  • RobertSlattery's avatar
    RobertSlattery
    8 years ago

    Yes, it's a bug.  Aparently fixed in the latest version.

hourir2's avatar
hourir2
Icon for Advocate I rankAdvocate I
6 years ago

Hi Guys,

For anyone that needs dates displayed as "dd-MMM-yy" for instance, you can create a measure:

formatdate = FORMAT(LASTDATE(date_table[date_col]),"dd-mmm-yy"), then pull the measure into your visual.

Sometimes You may need the original date_col values in your table but you can hide them at the end/off screen etc.