Forum Discussion
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," ...
Then you can try adding a conditional column with if [MonthNo] = 1 then [MonthName] = "JAN" for every one month.
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,
Hi Ausrine,
I have used direct query for this.
How to use your solution in direct query?
Regards,
Manivannan M
Then you can try adding a conditional column with if [MonthNo] = 1 then [MonthName] = "JAN" for every one month.
You should have written the full formula . :manhappy:
