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

摘要:公式生成日期维度表 阅读全文
posted @ 2017-06-22 12:13 vitas2015 阅读(32449) 评论(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 阅读(542) 评论(0) 推荐(0)
摘要:计算第一次购买时间 CALCULATE(FIRSTDATE(FactInternetSales[OrderDate]),ALLEXCEPT(FactInternetSales,FactInternetSales[CustomerKey])) 添加一个计算列,如果是第一次购买则为New,反之为Old 阅读全文
posted @ 2017-02-20 17:35 vitas2015 阅读(1007) 评论(0) 推荐(0)