随笔分类 - 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
阅读全文
摘要：ref：Display Last Refreshed Date in Power BI - The Excelguru BlogThe Excelguru Blog Display the Last Refreshed Date in Power BI Generate Last Refreshed
阅读全文
posted @ 2022-06-24 19:49
po-A
摘要：在visual块，右键Column选择Conditional formatting 举例，比如difference > 0 显示红色，否则<0显示绿色 如何根据 measure 写特定条件来更换背景色呢？ 举例：先创建measure ：TY FCST VS AOP Color = if (Data[
阅读全文
摘要：CONCATENATEX(<table>, <expression>[, <delimiter> [, <orderBy_expression> [, <order>]]...]) REF:https://community.powerbi.com/t5/Desktop/display-multip
阅读全文
摘要：右键parameter，选择Enable load 然后就能看到啦！ 其他问题: Passing Parameters in measures https://community.powerbi.com/t5/Desktop/Passing-Parameters-in-measures/m-p/20
阅读全文
摘要：问题描述：打开power bi desktop时报错。 WebView2 Process failed: explorationBrowser, Source:https://ms-pbi.pbi.microsoft.com/pbi/Web/Views/reportView.hrm 这个和浏览器Ed
阅读全文
摘要：配置163邮箱 网易163密码-》新增授权密码
阅读全文
摘要：Log片段： Property(S): ProductToBeRegistered = 1MSI (s) (9C:38) [21:32:16:311]: Note: 1: 1708 MSI (s) (9C:38) [21:32:16:311]: Note: 1: 2205 2: 3: Error M
阅读全文
摘要：精华部分： Once connected, you will see a list of tables in your Power Pivot Data model on the left. The next step is to switch to the DMV tab down the bot
阅读全文
摘要：如何解决？ APPLY CHANGES- POP UP ERROR: Microsoft SQL:A connection was successfully established with the server but then an error occurred during the pre-l
阅读全文
摘要：问题：Power bi 分享report给外部用户，非自己邮箱域名的用户。外部用户会发现在"Shared with Me"里不出现report的link。 答案：Currently when you share a report or dashboard externally it will not
阅读全文
摘要：ref： Community Account Support - Microsoft Power BI Community 所有情况都在上方的ref里。 'Need admin approval' message Message: Power BI Community needs permissio
阅读全文
摘要：有种情况在我们update app的时候，报错说：someone recently deleted this app Once we're done removing it (which can take up to 10 minutes) it will disappear from your l
阅读全文
摘要：Date Table = VAR BaseCalendar = CALENDAR(DATE(2018,1,1),DATE(2029,12,31)) RETURN GENERATE(BaseCalendar, VAR BaseDate = [Date] VAR YearDate = Year(Base
阅读全文
摘要：去年：year(today())-1，例如今年是2021年，那么year(today())-1 = 2020年。 创建相关的年初、末的参数： I've created (measures) for relative variable year start and end e.g. This year
阅读全文
摘要：碰到下面的问题怎么解决呢？ 情景：用Account A 登陆成功，但是用Account B登陆进去后会报下面的错误。 You have an account with usYou’re using xx@xx.com with another Microsoft service already. T
阅读全文
浙公网安备 33010602011771号