powerbi - 循环依赖计算列 Power BI Desktop
问题描述
在我的计算表中,变量AsOfDate
应该由切片器反映,切片器dim_Date
也是计算表。
从与 有关系的表CrossTableEffectiveDate
派生的计算表。fact_Premium
Date
dim_Date
我收到错误:Circular Dependency Calculated Column
CrossTableEffectiveDate =
VAR AsOfDate = VALUE("2019-01-31") //This value should be based on date value in a slicer
VAR CrossTables =
CROSSJOIN(
SUMMARIZE(fact_Premium,
fact_Premium[PolicyNumber],
fact_Premium[CompanyLocationGuid],
fact_Premium[Coverage],
fact_Premium[State],
fact_Premium[SICCode],
fact_Premium[ASLOB],
fact_Premium[ProducerGUID],
"Start", MIN(fact_Premium[EffectiveDate]),
"End", MAX(fact_Premium[ExpirationDate]),
"Premium", SUM(fact_Premium[Premium])
),
'Calendar')
VAR RiskPeriods =
ADDCOLUMNS(
FILTER(CrossTables,
'Calendar'[EoMonth] >= [Start] && 'Calendar'[Month] <= [End] && 'Calendar'[Month] <= AsOfDate),
"StartRiskMonth", IF([Start] > 'Calendar'[Month], [Start], 'Calendar'[Month]),
"EndRiskMonth", IF([End] < 'Calendar'[EoMonth], [End], 'Calendar'[EoMonth])
)
RETURN SELECTCOLUMNS(RiskPeriods,
"PolicyNumber", fact_Premium[PolicyNumber],
"CompanyLocationGUID", fact_Premium[CompanyLocationGuid],
"Coverage",fact_Premium[Coverage],
"State", fact_Premium[State],
"SICCode",fact_Premium[SICCode],
"ASLOB", fact_Premium[ASLOB],
"ProducerGUID",fact_Premium[ProducerGUID],
"StartRiskMonth", [StartRiskMonth],
"EndRiskMonth", [EndRiskMonth],
"YearNum", YEAR('Calendar'[Month]),
"Qtr", ROUNDUP(MONTH('Calendar'[Month])/3, 0),
"MonthNum", MONTH('Calendar'[Month]),
"WrittenPremium", [Premium],
"DaysInMonth", [EndRiskMonth] - [StartRiskMonth] + 1,
//"EndRiskMonth-Start", [EndRiskMonth] - [StartRiskMonth] + 1,
//"End-Start",[End] - [Start] + 1,
"EarnedPremium", [Premium] *
DIVIDE([EndRiskMonth] - [StartRiskMonth] + 1, [End] - [Start] + 1))
如何使切片器AsOfDate
引用变量?Date
dim_Date
解决方案
推荐阅读
- javascript - 在滚动底部生成 div
- vb.net - 随机图像卡在一张图像上
- c# - HttpClient 未使用客户端证书进行双向 TLS 身份验证
- spring-boot-admin - 如何修复“⚠️配置 INFO 失败。” 尝试在 Spring Boot Admin 中设置 ROOT 记录器级别时?
- c# - 使用 Newtonsoft 将复杂的 JSON 转换为通用列表
- c - 获取 MacOS 进程 pid
- android - 如何在课堂上使用 Shared Preferences 来设置所有活动?
- ios - 从弹出窗口呈现自定义弹出窗口然后关闭第一个弹出窗口会导致闪烁
- azure - 如何使用 ARM 模板续订 SSL 证书?
- javascript - Uncaught TypeError: Object(...) is not a function at eval (global-styles.js)