随笔分类 - PowerBI
摘要：正确写法：先处理null值逻辑。 = Table.AddColumn(重命名的列, "IsTOGreaterThan0", each if [TurnoverCurrentYear] = null then "Y" else if [TurnoverCurrentYear] >0 then "Y"
阅读全文
摘要：Multiple calculations(complex measures and calculated columns) in large dataset will eat up much CPU and memory . In your scenario, there are some pro
阅读全文
摘要：报错： Details: "ODBC: ERROR [HY000] [Microsoft][DriverSupport] (1160) Cannot enable SSL for the connection when connecting to a server that has not enab
阅读全文
摘要：POWER BI - 需要进入advanced editor修改： Source = Table.Combine({Table.AddColumn(#"query A", "source query", each "query A") , Table.AddColumn(#"query B", "s
阅读全文
摘要：Custom Column - Power query 如果Status列的值为“Act" or "Actual"，那新的列值为"Act“，否则为”OTHER STATUS“。 if List.Contains( {"Act", "Actual"}, [Status] ) then "Act" el
阅读全文
