Bacancy Technology
Bacancy Technology represents the connected world, offering innovative and customer-centric information technology experiences, enabling Enterprises, Associates and the Society to Rise™.
12+
Countries where we have happy customers
1050+
Agile enabled employees
06
World wide offices
12+
Years of Experience
05
Agile Coaches
14
Certified Scrum Masters
1000+
Clients projects
1458
Happy customers
- About Us
-
Services
-
AI/ML
- AI Consulting
- Generative AI
- AI Development
- Computer Vision
- NLP
- AI And ML Services
- LLM Development
- Adaptive AI
- ML Consulting
- Deep Learning
- Tensorflow Development
- ML Development
Artificial Intelligence
Machine Learning
-
Platforms
- Salesforce Customization
- Salesforce Implementation
- Salesforce Integration
- Salesforce Development
- Salesforce Consulting
- Salesforce Appexchange
- Salesforce CPQ
- Salesforce Data Migration
- Salesforce Managed Services
- Salesforce Staff Augmentation
- Salesforce App Development
- Salesforce Classic To Lightning Migration
- Salesforce Service Cloud
- Salesforce Marketing Cloud
- Salesforce Sales Cloud
- Salesforce Commerce Cloud
- Salesforce Financial Services Cloud
- Salesforce Support
- Microsoft Dynamics Consulting
- Dynamics 365 Implementation
- Dynamics 365 Integration
- Dynamics 365 Customization
- Microsoft Dynamics 365 Support
- SAP Consulting
Salesforce
Microsoft
SAP
- Industries
- Technologies
- Hire Talent
- Portfolio
- Contact Us
- book a 30 min call
October 24, 2024
Format a Date in a Power BI Measure
You can use the FORMAT function in DAX to control how dates are displayed in Power BI measures. Here’s a simple example:
DAX:
FormattedDate = FORMAT([DateColumn], "MMMM DD, YYYY")
This will format your date as “October 23, 2024” (Month Day, Year). You can use different format strings depending on your needs:
- “MM/DD/YYYY” for Month/Day/Year (e.g., 10/23/2024)
- “DD-MM-YYYY” for Day-Month-Year (e.g., 23-10-2024)
- “YYYY-MM-DD” for Year-Month-Day (e.g., 2024-10-23)
If you’re working with null or blank values, you can handle them like this:
DAX:
FormattedDateWithCheck = IF(ISBLANK([DateColumn]), "No Date", FORMAT([DateColumn], "MMMM DD, YYYY"))
This ensures that blank values are displayed as “No Date” instead of causing errors.
Support On Demand!
