Forum Discussion
How do i plot a date with no values
v-alq-msft My data source is an excel spreadsheet, which i connect to it live from the workspace.
Im not able to create the calculated table for the date, as you show, that section is greyed out.
Is there a work around ?
I appreciate your patience.
Hi, iamflamingjune
I think you need to create a date table in the data source. It is unsupported to create a calculated table when using live connect mode.
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.