Forum Discussion
Manivannan
Helper I
Helper IMonth 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,
Then you can try adding a conditional column with if [MonthNo] = 1 then [MonthName] = "JAN" for every one month.
lravikiranHelper I
Helper IYou should have written the full formula . :manhappy: