将相同值应用于每个月的DAX度量
将相同值应用于每个月的DAX度量
提问于 2019-10-24 14:38:39
我试着用多种方法来巩固我的年终预测。我遇到了一个问题，我试图让九月的价值在所有几个月中展现出来。
注意，这不是完整的代码。
这对于我的CompMoCI变量来说是完美的。我无法让它为我的HisCompMoAvg变量工作。
SAIFI YEP =
var CurYr = YEAR(TODAY())
var CurMo = MONTH(TODAY())
var Yr1Back = CurYr - 1
var Yr2Back = CurYr - 2
var Yr3Back = CurYr - 3
var Yr4Back = CurYr - 4
var Yr5Back = CurYr - 5
var CurYrCI = CALCULATE(TOTALYTD([CI by Data Naming Convention], 'Date Table'[Date]), 'Year'[Year] = CurYr)
var CompMoCI = CALCULATE(TOTALYTD([CI by Data Naming Convention], 'Date Table'[Date]), 'Year'[Year] = CurYr, 'Date Table'[Monthnumber] = (CurMo-1), ALLSELECTED(Outages), ALLSELECTED('Date Table'), ALLSELECTED(Customers))
var Yr1BackCI = CALCULATE(TOTALYTD([CI by Data Naming Convention], 'Date Table'[Date]), 'Year'[Year] = Yr1Back)
var Yr2BackCI = CALCULATE(TOTALYTD([CI by Data Naming Convention], 'Date Table'[Date]), 'Year'[Year] = Yr2Back)
var Yr3BackCI = CALCULATE(TOTALYTD([CI by Data Naming Convention], 'Date Table'[Date]), 'Year'[Year] = Yr3Back)
var Yr4BackCI = CALCULATE(TOTALYTD([CI by Data Naming Convention], 'Date Table'[Date]), 'Year'[Year] = Yr4Back)
var Yr5BackCI = CALCULATE(TOTALYTD([CI by Data Naming Convention], 'Date Table'[Date]), 'Year'[Year] = Yr5Back)
var HisTotal = CALCULATE(Yr1BackCI + Yr2BackCI + Yr3BackCI + Yr4BackCI + Yr5BackCI, ALLSELECTED(Outages), ALLSELECTED('Date Table'[Date]), ALLSELECTED(Customers))
var HisTotalAvg = CALCULATE(HisTotal, ALLSELECTED(Outages), ALLSELECTED('Date Table'), ALLSELECTED(Customers))/5
var AvgMoAhead = if(MAX('Date Table'[Monthnumber]) >= CurMo, HisTotalAvg, 0)
var HisCompMoAvg = CALCULATE(HisTotalAvg, 'Date Table'[Monthnumber] = 9, ALLSELECTED(Outages), ALLSELECTED('Date Table'), ALLSELECTED(Customers))
var test = HisCompMoAvg
return test回答 1
Stack Overflow用户
发布于 2019-10-25 10:40:05
这个问题应该重新措辞。我们只能猜你想要什么。
+-------+-------+-----------------+
| month | sales | expected result |
+-------+-------+-----------------+
| Jan | 13 | 130 |
| Feb | 32 | 130 |
| Mar | 45 | 130 |
| Apr | 61 | 130 |
| May | 77 | 130 |
| Jun | 85 | 130 |
| Jul | 98 | 130 |
| Aug | 109 | 130 |
| Sep* | 130 | 130 |
| Oct | 151 | 130 |
| Nov | 178 | 130 |
| Dec | 196 | 130 |
+-------+-------+-----------------+有个问题。如何构造显示所有月份9月份销售额的DAX度量？
!Sales = SUM('Table'[sales])
YourMeasure = CALCULATE([!Sales], ALL('Table'[month]), 'Table'[month]="Sep")阅读关于所有函数、计算和KEEPFILTERS的内容。
DAX Calculate function with and without FILTER
Difference between CALCULATE(m, x=red) vs CALCULATE(m, KEEPFILTERS(x=red))
页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接：
https://stackoverflow.com/questions/58543729
复制相关文章
相似问题
腾讯云开发者
