随笔分类 - 数据分析(SSAS)
摘要:公式生成日期维度表
阅读全文
摘要: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 ...
阅读全文
摘要:计算第一次购买时间 CALCULATE(FIRSTDATE(FactInternetSales[OrderDate]),ALLEXCEPT(FactInternetSales,FactInternetSales[CustomerKey])) 添加一个计算列,如果是第一次购买则为New,反之为Old
阅读全文