SSAS表格日期字段在Excel过滤器/排序中不能用作日期 [英] SSAS Tabular Date Fields not working as Dates in Excel filters/sorting

问题描述

我在SSAS Tabular中构建了几个数据模型。这些模型中的许多表格都有
日期字段。

我没有或不需要与每个日期字段相关联的日期维度，但我希望日期将被excel检测为日期，人们将能够使用该标准Excel中的日期类型字段的过滤和排序选项。 

我已就此主题进行了大量搜索。有一些帖子表明如何在SSAS多维立方体中解决它，但我还没有找到关于SSAS表格的任何明确指南。  

 

解决方案

您好VivDev，

感谢您的提问。

>>>我已就此主题进行了大量搜索。有一些帖子表明如何在SSAS多维立方体中解决它，但我还没有找到关于SSAS表格的任何权威指南。 


对于这个问题，请参考下面类似的主题：

https://stackoverflow.com/questions/25922077/how-to-sort-date-columns-by -date-代替-的-按字母顺序时-连接到SS

I have several data models built in SSAS Tabular. Lot of the tables in those models have date fields.

I don't have or need a date dimension associated to each of those date fields but I was hoping the dates will be detected as dates by excel and folks will be able to use the standard filtering and sorting options in Excel for date type fields. 

I've done plenty of searching on this topic. There are some posts that indicate how to solve it in SSAS multi-dimensional cubes but I haven't found any definitive guide on SSAS Tabular yet.  

 

解决方案

Hi VivDev，

Thanks for your question.

>>>I've done plenty of searching on this topic. There are some posts that indicate how to solve it in SSAS multi-dimensional cubes but I haven't found any definitive guide on SSAS Tabular yet. 
For this issue, please refer to below similar thread:
https://stackoverflow.com/questions/25922077/how-to-sort-date-columns-by-date-instead-of-alphabetically-when-connecting-to-ss

这篇关于SSAS表格日期字段在Excel过滤器/排序中不能用作日期的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！