Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Date Formatting in Custom Columns

Hi all! Can anyone tell me how to format a date field using a Custom Column where the date is formatted to MMM-YYYY?
Need Help
  • amaniramahi's avatar
    amaniramahi
    6 years ago

    go to the table that contains the date column

    select the date column

    column tool tab will appear

    in the format, enter mmm-yyyy "in small letters" as below image

     

    tell me what you got, this should work

     

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Thanks this explians everything, I'm very knew to PowerBI, where and when is Dax used?

 

I'm trying to create a seperate column which shows the date as MMM-YYYY, do you have any step by step instructions on how I do this if it's not done via a Custom Column?

 

Many Thanks

amaniramahi's avatar
amaniramahi
Icon for Helper V rankHelper V
6 years ago

which version do you use? is it March 2020 version?

you can find it from File>About>Version

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi Amaniramahi,

     

     

    I use the following version

    Version: 2.79.5768.1082 64-bit (March 2020)

    • amaniramahi's avatar
      amaniramahi
      Icon for Helper V rankHelper V
      6 years ago

      go to the table that contains the date column

      select the date column

      column tool tab will appear

      in the format, enter mmm-yyyy "in small letters" as below image

       

      tell me what you got, this should work

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        Hi Amanirmahi,

         

        This works perfectly thank you!