Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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])
)
User | Count |
---|---|
107 | |
89 | |
81 | |
76 | |
73 |
User | Count |
---|---|
112 | |
104 | |
96 | |
74 | |
66 |