week end date split out in to DD MMM YYYY columns

[TAP936]

I have a week end date field but no other dates, I want day, month, year columns so I can create some time intelligence measures. Can anyone help, i'm new to dax?

thanks

[v-alq-msft]

Hi, @TAP936 

If you take the answer of someone, please mark it as the solution to help the other members who have same problems find it more quickly. If not, let me know and I'll try to help you further. Thanks.

Best Regards

Allan

[v-alq-msft · Accepted solution]

Hi, @TAP936 

If you do not have a Date table in your data source, I'd like to suggest you create a date table directly in the data model by adding calculated columns(day, month, year columns) to a table built by using either CALENDAR or CALENDARAUTO .

Generally, your data model will contain a calendar table. It is better to aggregate data by year and month using columns of a calendar table (containing one row for each day) instead of extracting the date parts from a single column of type date or datetime in calculated columns. You obtain a model wherein all date attributes are included in a separate table making it easier to browse data using a generic client, and you can use special DAX functions that perform time intelligence calculations. Moreover, most of the time intelligence functions require a separate Date table to work correctly.

Best Regards

Allan

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@TAP936 , if it is a date you can most of the stuff out of it

Month = month([Date])

Month year = format([Date],"MMM YYYY")

Year =year([Date])

Month Start =eomonth([Date],-1)+1

Month End=eomonth([Date],0)

Week Day = weekday([Date])