Forum Discussion

Manivannan's avatar
Manivannan
Helper I
9 years ago
Solved

Month Name

Hi All,

 

I have created a direct query to display month. But it is displaying in numbers.

This is the query i used : "DATEPART("MONTH" , [AxDB].[dbo].[CUSTINVOICETRANS].[INVOICEDATE]) as Month,"

 

 

Actually i need it to be displayed in name, like JAN, FEB & MAR so on....

Kindly suggest a solution.

 

 

 

Regards,

Manivannan M

 

Need Help
  • ausrine's avatar
    ausrine
    9 years ago

    Then you can try adding a conditional column with if [MonthNo] = 1 then [MonthName] = "JAN" for every one month. 

  • v-sihou-msft's avatar
    v-sihou-msft
    9 years ago

    Manivannan

     

    In Direct Query mode, all direct format approach with DAX/POWER QUERY will not work. You can only use SWITCH() to get the Month Name as ausrine suggested. 

     

     

    Regards,

     

     

6 Replies

  • ausrine's avatar
    ausrine
    Frequent Visitor
    9 years ago

    Hi Manivannan,

    You can do it manually, using:

    MonthName =
SWITCH (
    Table[MonthNo],
    1, "JAN",
    2, "FEB",
    3, "MAR",
    4, "APR",
    5, "MAY",
    6, "JUN",
    7, "JUL",
    8, "AUG",
    9, "SEP",
    10, "OCT",
    11, "NOV",
    12, "DEC",
    BLANK ()
)

    Cheers,

    Ausrine

    • Manivannan's avatar
      Manivannan
      Helper I
      9 years ago

      Hi Ausrine,

       

      I have used direct query for this.

      How to use your solution in direct query?

       

       

      Regards,

      Manivannan M

       

      • ausrine's avatar
        ausrine
        Frequent Visitor
        9 years ago

        Then you can try adding a conditional column with if [MonthNo] = 1 then [MonthName] = "JAN" for every one month.