Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Learn more
I would like to create a date table in French language , All months and dates should show in French. Is it possible to do that by using DAX?
It is either you change the configuration of PBI Desktop :
or using DAX :
Date Table =
ADDCOLUMNS (
CALENDAR (DATE(2020,1,1), DATE(2030,12,31)), -- Adjust the date range as needed
"Year", YEAR([Date]),
"Month Number", MONTH([Date]),
"Month Name", FORMAT([Date], "MMMM", "fr-FR"),
"Day of Week Number", WEEKDAY([Date]),
"Day of Week Name", FORMAT([Date], "dddd", "fr-FR"),
"Day", DAY([Date])
)
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Check out the October 2025 Power BI update to learn about new features.