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," ...
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,

     

     

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. 

      • lravikiran's avatar
        lravikiran
        Helper I
        7 years ago

        You should have written the full formula . :manhappy:

    • v-sihou-msft's avatar
      v-sihou-msft
      Microsoft Employee
      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,