Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
Solved! Go to Solution.
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 @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
Hi Ausrine,
I have used direct query for this.
How to use your solution in direct query?
Regards,
Manivannan M
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.
You should have written the full formula .
Try FORMAT function with "mmm".
User | Count |
---|---|
141 | |
113 | |
104 | |
78 | |
64 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |