<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/aaron19822007</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; aaron19822007]]></copyright><item><title><![CDATA[Quick BI中lod函数中第二个参数形式上必须为聚合函数]]></title><link>https://blog.youkuaiyun.com/aaron19822007/article/details/144520421</link><guid>https://blog.youkuaiyun.com/aaron19822007/article/details/144520421</guid><author>aaron19822007</author><pubDate>Mon, 16 Dec 2024 23:15:50 +0800</pubDate><description><![CDATA[虽然新建计算字段“周存销比“与”SUM([期末库存])/SUM([销售数量])“，本质是上一样的，但是lod_exclude函数在语法检查上，却是要求第二个参数形式上必须为聚合函数。]]></description><category></category></item><item><title><![CDATA[Quick BI中lod_fixed函数数据计算过程解析]]></title><link>https://blog.youkuaiyun.com/aaron19822007/article/details/139389058</link><guid>https://blog.youkuaiyun.com/aaron19822007/article/details/139389058</guid><author>aaron19822007</author><pubDate>Sun, 02 Jun 2024 11:34:01 +0800</pubDate><description><![CDATA[lod_fixed函数数据计算过程
1、根据“过滤条件”进行内部过滤
2、根据声明维度进行分组聚合
 （1）保留声明维度和聚合维度
 （2）根据声明维度进行聚合计算
3、制作仪表板
 （1）只接受来自声明维度的过滤筛选作用]]></description><category></category></item><item><title><![CDATA[基于Power BI的购物篮分析]]></title><link>https://blog.youkuaiyun.com/aaron19822007/article/details/136411672</link><guid>https://blog.youkuaiyun.com/aaron19822007/article/details/136411672</guid><author>aaron19822007</author><pubDate>Mon, 04 Mar 2024 10:00:00 +0800</pubDate><description><![CDATA[在Power BI中实现购物篮分析]]></description><category></category></item><item><title><![CDATA[基于Quick BI的购物篮分析]]></title><link>https://blog.youkuaiyun.com/aaron19822007/article/details/136374849</link><guid>https://blog.youkuaiyun.com/aaron19822007/article/details/136374849</guid><author>aaron19822007</author><pubDate>Fri, 01 Mar 2024 10:00:00 +0800</pubDate><description><![CDATA[购物篮分析，就是通过研究用户消费数据，将不同商品之间进行关联，并挖掘二者之间联系的分析方法，也称做商品关联分析法。]]></description><category></category></item><item><title><![CDATA[Quick BI中有关IF语句中使用Lod函数问题分析]]></title><link>https://blog.youkuaiyun.com/aaron19822007/article/details/136168109</link><guid>https://blog.youkuaiyun.com/aaron19822007/article/details/136168109</guid><author>aaron19822007</author><pubDate>Tue, 20 Feb 2024 10:00:00 +0800</pubDate><description><![CDATA[新建计算字段“总结存数量=if(count(distinct [月份])=1,sum([结存数量]),lod_include{[月份]:SUM([结存数量]):[月份]='5月'})”，即当”月份”个数为1时，直接对“结存数量”求和，当“月份”个数不为1时，只对“5月”的“结存数量“求和。]]></description><category></category></item><item><title><![CDATA[Quick BI中查询控件与复合式查询控件结果不一致问题分析]]></title><link>https://blog.youkuaiyun.com/aaron19822007/article/details/136114478</link><guid>https://blog.youkuaiyun.com/aaron19822007/article/details/136114478</guid><author>aaron19822007</author><pubDate>Mon, 19 Feb 2024 10:00:00 +0800</pubDate><description><![CDATA[为什么，同样的查询条件下，“查询控件”和“复合式查询控制”的结果会不一样呢？]]></description><category></category></item><item><title><![CDATA[Quick BI中lod函数之lod_exclude]]></title><link>https://blog.youkuaiyun.com/aaron19822007/article/details/135987264</link><guid>https://blog.youkuaiyun.com/aaron19822007/article/details/135987264</guid><author>aaron19822007</author><pubDate>Sun, 04 Feb 2024 10:00:00 +0800</pubDate><description><![CDATA[lod_exclude的执行逻辑：先按内部和外部过滤条件进行过滤，若外部过滤字段属于声明维度则无效，然后进行聚合计算，形成一张虚表，所以lod_exclude函数返回的是一张表，通常需要聚合后才能使用。由于这里是去除声明的维度，因此并没有指定分组维度，所以返回的表只有一行。]]></description><category></category></item><item><title><![CDATA[Quick BI中lod函数之lod_include]]></title><link>https://blog.youkuaiyun.com/aaron19822007/article/details/135987204</link><guid>https://blog.youkuaiyun.com/aaron19822007/article/details/135987204</guid><author>aaron19822007</author><pubDate>Sat, 03 Feb 2024 10:00:00 +0800</pubDate><description><![CDATA[lod_include的执行逻辑：先按内部和外部的过滤条件进行过滤，再按声明维度进行分组，然后进行聚合运算，形成一张虚表，所以lod_fixed函数返回的是一张表，通常需要聚合后才能使用]]></description><category></category></item><item><title><![CDATA[Quick BI中lod函数之lod_fixed]]></title><link>https://blog.youkuaiyun.com/aaron19822007/article/details/135986765</link><guid>https://blog.youkuaiyun.com/aaron19822007/article/details/135986765</guid><author>aaron19822007</author><pubDate>Fri, 02 Feb 2024 09:42:08 +0800</pubDate><description><![CDATA[lod_fixed的执行逻辑：先按内部过滤条件进行过滤，若外部过滤字段不属于声明维度则无效，再按声明维度进行分组，然后进行聚合计算，形成一张虚表，所以lod_fixed函数返回的是一张表，通常需要聚合后才能使用。]]></description><category></category></item><item><title><![CDATA[有关Quick BI中Case子句中多次使用lod函数返回空值问题分析]]></title><link>https://blog.youkuaiyun.com/aaron19822007/article/details/135783288</link><guid>https://blog.youkuaiyun.com/aaron19822007/article/details/135783288</guid><author>aaron19822007</author><pubDate>Thu, 25 Jan 2024 20:00:00 +0800</pubDate><description><![CDATA[有关Quick BI中Case子句中多次使用lod函数，返回空值问题分析]]></description><category></category></item><item><title><![CDATA[有关Quick BI中lod_include函数两次保存计算结果前后不一致问题分析]]></title><link>https://blog.youkuaiyun.com/aaron19822007/article/details/135760724</link><guid>https://blog.youkuaiyun.com/aaron19822007/article/details/135760724</guid><author>aaron19822007</author><pubDate>Wed, 24 Jan 2024 08:00:00 +0800</pubDate><description><![CDATA[有关Quick BI中lod_include函数两次保存计算结果前后不一致问题分析]]></description><category></category></item><item><title><![CDATA[有关Quick BI中新建字段被引用时出错问题分析]]></title><link>https://blog.youkuaiyun.com/aaron19822007/article/details/135727361</link><guid>https://blog.youkuaiyun.com/aaron19822007/article/details/135727361</guid><author>aaron19822007</author><pubDate>Tue, 23 Jan 2024 20:00:00 +0800</pubDate><description><![CDATA[（3）新建计算字段“非烟订单数量=lod_include{[是否卷烟]:COUNT(distinct [流水号]):[是否卷烟]='非烟'}”（3）同时购买卷烟和非烟订单：零售订单中既有卷烟又有非烟商品的订单，同时购买卷烟和非烟订单数量=卷烟订单数量+非烟订单数量-零售订单数量。（4）新建计算字段“同时购买卷烟和非烟订单数量=[卷烟订单数量]+[非烟订单数量]-[零售订单数量]”（4）购买卷烟中购买非烟比例=同时够买卷烟和非烟订单数 / 卷烟订单数。（2）非烟订单：零售订单中有非烟商品的订单。]]></description><category></category></item><item><title><![CDATA[有关quick bi中lod_include函数有多个过滤条件报错问题分析]]></title><link>https://blog.youkuaiyun.com/aaron19822007/article/details/135726838</link><guid>https://blog.youkuaiyun.com/aaron19822007/article/details/135726838</guid><author>aaron19822007</author><pubDate>Mon, 22 Jan 2024 20:00:00 +0800</pubDate><description><![CDATA[WHERE子句后面有多个过滤条件时，应用AND或OR连接。]]></description><category></category></item><item><title><![CDATA[有关Quick BI中当返回值为空值，行标题消失问题]]></title><link>https://blog.youkuaiyun.com/aaron19822007/article/details/135723623</link><guid>https://blog.youkuaiyun.com/aaron19822007/article/details/135723623</guid><author>aaron19822007</author><pubDate>Sun, 21 Jan 2024 20:00:00 +0800</pubDate><description><![CDATA[当右表中没有匹配的记录时，也要显示左表中的记录，应该使用外左外连接LEFT JOIN]]></description><category></category></item><item><title><![CDATA[有关Quick BI中lod_fixed函数中以MAX()作为过滤条件报错]]></title><link>https://blog.youkuaiyun.com/aaron19822007/article/details/135722045</link><guid>https://blog.youkuaiyun.com/aaron19822007/article/details/135722045</guid><author>aaron19822007</author><pubDate>Sat, 20 Jan 2024 21:27:20 +0800</pubDate><description><![CDATA[在SQL中where子句后面不能直接跟聚合函数，但是可以通过子查询，在子查询中使用聚合函数]]></description><category></category></item><item><title><![CDATA[Power BI中实现购物篮分析详解]]></title><link>https://blog.youkuaiyun.com/aaron19822007/article/details/132199015</link><guid>https://blog.youkuaiyun.com/aaron19822007/article/details/132199015</guid><author>aaron19822007</author><pubDate>Wed, 09 Aug 2023 22:44:54 +0800</pubDate><description><![CDATA[在Power BI中实现购物篮分析步骤详细介绍]]></description><category></category></item><item><title><![CDATA[Power BI 筛选器函数---Window实例详解]]></title><link>https://blog.youkuaiyun.com/aaron19822007/article/details/128931365</link><guid>https://blog.youkuaiyun.com/aaron19822007/article/details/128931365</guid><author>aaron19822007</author><pubDate>Sun, 12 Feb 2023 09:56:20 +0800</pubDate><description><![CDATA[WINDOW函数，对指定分区（PartitioinBy)中的行（关系表），按指定的列进行排序（OrderBy）后，根据（起始位置）和（结束位置）定位多行。]]></description><category></category></item><item><title><![CDATA[Power BI 筛选器函数---Index实例详解]]></title><link>https://blog.youkuaiyun.com/aaron19822007/article/details/128930956</link><guid>https://blog.youkuaiyun.com/aaron19822007/article/details/128930956</guid><author>aaron19822007</author><pubDate>Fri, 10 Feb 2023 10:22:41 +0800</pubDate><description><![CDATA[INDEX函数，对指定分区(PartitioinBy)中的行（关系表），按指定的列进行排序(OrderBy)后，根据（检索行号）定位单行。]]></description><category></category></item><item><title><![CDATA[Power BI 筛选器函数---Offset实例详解]]></title><link>https://blog.youkuaiyun.com/aaron19822007/article/details/128930282</link><guid>https://blog.youkuaiyun.com/aaron19822007/article/details/128930282</guid><author>aaron19822007</author><pubDate>Wed, 08 Feb 2023 10:03:41 +0800</pubDate><description><![CDATA[Offset函数，对指定分区(PartitioBy)中的行（关系表）,按指定的列进行排序(OrderBy)后，根据（行偏移量）定位单行。]]></description><category></category></item><item><title><![CDATA[Power BI中如何实现移动平均功能]]></title><link>https://blog.youkuaiyun.com/aaron19822007/article/details/128823582</link><guid>https://blog.youkuaiyun.com/aaron19822007/article/details/128823582</guid><author>aaron19822007</author><pubDate>Fri, 03 Feb 2023 19:14:01 +0800</pubDate><description><![CDATA[数据分析，经常会遇到计算移动平均问题。Power BI中如何实现移动平均功能。本文介绍Power BI中实现移动平均的两种类型，一种是Power BI数据模式下，通过新建列来计算移动平均值；一种是Power BI报表模式下，通过新建度量值来计算移动平均值，这种情况下，又分为两种静态移动平均和动态移动平均。]]></description><category></category></item></channel></rss>