Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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 |
---|---|
88 | |
72 | |
69 | |
65 | |
57 |
User | Count |
---|---|
93 | |
93 | |
91 | |
76 | |
69 |