I have Year number and Month Number in my data. How using DAX can I get the month name out of month number?
In SSRS it is very easy. But how to achieve that using DAX?
We can use :
MonthName = FORMAT(DATE(1, [Num], 1), "MMM")
We need a simple reconstruction of a fake date from the month number provided, and reformat it with the FORMAT function.
As an alternative, we can go the old-fashioned way and write a SWITCH statement and hard-coded for the 12 months. It's up to you.
Check out the Power BI Microsoft certification course provided by Intellipaat to learn and master this tool.
Certification in Digital Marketing |
Certification in Big Data Analytics |
Certification in Cloud & Devops |
Certification in Full Stack Web Development
Big Data and Data Science Master’s Course |
Data Science Architect Master’s Program |
Cloud and DevOps Architect Master’s Course |
Artificial Intelligence Engineer Master’s Course |
Microsoft Azure Certification Master’s Training
Data Science Course Online |
Big Data Hadoop Certification Training |
Machine Learning Course Online |
Artificial Intelligence Course and Training |
Salesforce Certification Training: Administrator and App Builder |
Tableau Training and Certification Course |
Python Data Science Course & Training |
Ethical Hacking Course |
Business Analyst Course |
Courses in Cyber Security
© COPYRIGHT 2011-2021 INTELLIPAAT.COM. ALL RIGHTS RESERVED.
Download Salary Trends Now !
Learn how professionals like you got up to 100% Salary Hike.