Forum Discussion
Jackofall
Resolver I
Resolver IDate Table, add a text column as well
This works well but I want one column to come out as text so I don't have to change it afterwards. Date =
ADDCOLUMNS (
CALENDAR (DATE(2000;1;1); DATE(2025;12;31));
"DateAsInteger"; FORMAT ( [Date];...
You dont need to create a custom calendar using DAX.
There are already custom calendars, created using Power Query, available online.
You can also download the customer calendar from this link.
Obviously you can add more info to it if you want
If you want to move it across reports just simply copy and paste it.
themistoklis
Community Champion
Community Champion
You dont need to create a custom calendar using DAX.
There are already custom calendars, created using Power Query, available online.
You can also download the customer calendar from this link.
Obviously you can add more info to it if you want
If you want to move it across reports just simply copy and paste it.
JackofallThanks I will look at it.