Forum Discussion

thorrrr's avatar
thorrrr
Helper I
9 years ago
Solved

Newbie DAY Function sorry

HI Guys

I have a column A with a short date format. I want to add a custom column to it and use the DAY excel function to return the day of each month.

What is the syntax I have looked here but when I try it nothing works I get errors all the time? Sorry I know it is probably me but trying to get my head round Power BI

Show and Tell
  • Anonymous's avatar
    Anonymous
    9 years ago

    sorry in your case in the "custom column formua:" box:

    = each Date.Day([Date])

6 Replies

    • thorrrr's avatar
      thorrrr
      Helper I
      9 years ago

      Just get an error if i use your solution 

      • Anonymous's avatar
        Anonymous
        Not applicable
        9 years ago

        Hi Thorrr, 

        try the following = each Date.Day([ShortDate]) 

         

        i think i can see where you made the mistake.

         

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    Hi Thorr, 

    i notice you would like to apply the Day function in the M language (going into editing the query).  

    I have a column named, "ShortDate" containing the short dates.  and I have simply added a new "custom column" from the add column tab.  and then applied the formula:  = Table.AddColumn(#"Removed Columns", "Custom", each Date.Day([ShortDate]))

     

    The above worked.  I noticed that the formula is case sensitive.

    I hope this helps.

    • thorrrr's avatar
      thorrrr
      Helper I
      9 years ago

      Hi

       

      Does not work for me I get a new column called Custom with Table in every entry