Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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".
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
111 | |
92 | |
84 | |
66 |