时间戳

首页 > 解决方案 > POWER BI 中迄今为止的 AD 登录时间

powerbi - POWER BI 中迄今为止的 AD 登录时间

问题描述

我正在尝试将 AD lastlogon 转换为日期。即使高级编辑器没有显示错误，带有我的公式的自定义列仍然显示错误 在此处输入图像描述

标签： powerbidax

解决方案

你能试试这个if (condition) then (outcome) else (outcome)。if then else必须是小写

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMlSK1YlWMlKKjQUA", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Column1 = _t]),
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Column1", Int64.Type}}),
    #"Added Custom" = Table.AddColumn(#"Changed Type", "Custom", each if [Column1]=1 then (1) else (0))
in
    #"Added Custom"

对比

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMlSK1YlWMlKKjQUA", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Column1 = _t]),
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Column1", Int64.Type}}),
    #"Added Custom" = Table.AddColumn(#"Changed Type", "Custom", each IF([Column1]=1,1,0))
in
    #"Added Custom"

推荐阅读