PowerBI中同比环比那点事

最新推荐文章于 2024-09-27 16:32:32 发布

易心意

最新推荐文章于 2024-09-27 16:32:32 发布

阅读量1.1k

点赞数

分类专栏： BI

原文链接：https://mp.weixin.qq.com/s?__biz=MzU5Njk0MjczNQ==&mid=2247484310&idx=1&sn=5f8dd9e681f01c5d1f0ac471be57564b&chksm=fe5a4976c92dc060844e64319a7c5ff67b870d958a937d2f79ae2bb581ee42f83db2904663de&mpshare=1&scene=1&srcid=0518Te6GwP7qsGoEm8bI4bqr&sharer_sharetime

版权

BI 专栏收录该内容

3 篇文章 1 订阅

订阅专栏

本期=sum(‘成交量时间’[单量])

上期=CALCULATE([本期],DATEADD(‘日期’[Date],-1,DAY))
上期=CALCULATE([本期],DATEADD(‘日期’[Date],-1,MONTH))

差额=[本期]-[上期]

日环比=DIVIDE([差额],[上期])

https://mp.weixin.qq.com/s?__biz=MzU5Njk0MjczNQ==&mid=2247484310&idx=1&sn=5f8dd9e681f01c5d1f0ac471be57564b&chksm=fe5a4976c92dc060844e64319a7c5ff67b870d958a937d2f79ae2bb581ee42f83db2904663de&mpshare=1&scene=1&srcid=0518Te6GwP7qsGoEm8bI4bqr&sharer_sharetime=1599030410811&sharer_shareid=4b52e7132b16837219f4cb27bfe4961b&key=b24ae40b088eee6ebdc8728a80b33640797608cb0dd13bf8875ad375c3db8ead803f9b05af51adb8e4b9c23f3d4ac1a1f79bcb6545b3e53e1136414be78ffe75e9001192e47dfc799c628ccdd1271363fd9cc669fda3c9a89eb5482e2dd5275901a5d287a41b1e9a454cd55c1e8b0dc055bd6dd992d93f5750364297e6a912c1&ascene=1&uin=MTExNzg1ODkyOQ%3D%3D&devicetype=Windows+10+x64&version=62090529&lang=zh_CN&exportkey=ATxo7uxJOeVW9HBk5d36x1E%3D&pass_ticket=A6m0vdyefsr7XO106LWq2Nlni6sRsha9eRQyi%2FqWXQ1HTzsmHPyeG0IfJK78%2BY7W