随笔分类 -  数据分析(SSAS)

摘要:公式生成日期维度表 阅读全文
posted @ 2017-06-22 12:13 vitas2015 阅读(31901) 评论(2) 推荐(0) 编辑
摘要:The New and Returning Customers pattern dynamically calculates the number of customers with certain behaviors based on their purchase history. This calculation can be computing-intensive and, thus, a ... 阅读全文
posted @ 2017-05-05 11:03 vitas2015 阅读(489) 评论(0) 推荐(0) 编辑
摘要:计算第一次购买时间 CALCULATE(FIRSTDATE(FactInternetSales[OrderDate]),ALLEXCEPT(FactInternetSales,FactInternetSales[CustomerKey])) 添加一个计算列,如果是第一次购买则为New,反之为Old 阅读全文
posted @ 2017-02-20 17:35 vitas2015 阅读(983) 评论(0) 推荐(0) 编辑

点击右上角即可分享
微信分享提示