Forum Discussion

joeytsui's avatar
joeytsui
Helper I
7 years ago
Solved

Date Format issue

Hi All,

 

I have a table which is contain a date field, and i change it to "date only" on power query, and it shown correct under power query and slicer in PBI desktop.

however i create a table show customerno and lastest date, the it show the full date, see attached photo.

Is it possible to show the short date format on the table, just like the slicer and power query ?

 

Thanks in advance.

 

Joey


 

Need Help
  • mussaenda's avatar
    mussaenda
    7 years ago

    Select your Column Date and go to the Modeling tab. there is a data type there and format where you can change it.

3 Replies

  • Ani1991's avatar
    Ani1991
    Resolver III
    7 years ago

    Hi joeytsui 

    Use the below formula to create a calculated column.

    Formateddate = FORMAT(DateDim[Date],"dd/MM/yyyy")
     
    Thanks,
    Ani
  • mussaenda's avatar
    mussaenda
    Community Champion
    7 years ago

    Select your Column Date and go to the Modeling tab. there is a data type there and format where you can change it.