Forum Discussion

S184019's avatar
S184019
Advocate III
7 years ago
Solved

Formatting not working properly

I've a simple table with a date field called "ServDate" formatted as a date *3/14/2001 with values ranging from 9/4/2018 to 3/29/2019.   The table has ~134K rows. Creating a new column like this MMM...
Data Modeling
  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    7 years ago

    Hi S184019, 

     

    Please modify the DAX like below: 

     

    MMM-YY = CONCATENATE(FORMAT(Dates[Date],"MMM"),CONCATENATE("-",RIGHT(YEAR(Dates[Date]),2)))
     

     

    Best Regards,
    Qiuyun Yu 

v-qiuyu-msft's avatar
v-qiuyu-msft
Community Support
7 years ago

Hi S184019, 

 

Please modify the DAX like below: 

 

MMM-YY = CONCATENATE(FORMAT(Dates[Date],"MMM"),CONCATENATE("-",RIGHT(YEAR(Dates[Date]),2)))
 

 

Best Regards,
Qiuyun Yu