Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Date Format YYYYMM

Hi,   I have a date column which is of format MMMM,YYYY viz. July,2019 for example. This column is also used a  report level filter.    The user wants to see the date as YYYYMM format. I was not ...
Need Help
Show and Tell
Tips and Tricks
  • v-xicai's avatar
    v-xicai
    6 years ago

    Hi Anonymous  ,

     

    Does that make sense? If so, kindly mark my answer as a solution to help others having the similar issue and close the case. If not, let me know and I'll try to help you further.

     

    Best regards

    Amy

v-xicai's avatar
v-xicai
Community Support
6 years ago

Hi Anonymous ,

 

You can create column like DAX below.

 

Date Format = FORMAT(Table1[Date],"YYYYMM")

 

Best Regards,

Amy

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.