POWER BI dataflow: công thức if

 Table.AddColumn(#"Changed column type 1", "Custom", each if[Milestone] = "LDM" then [Target sample shipped] - [LDM Sample Shipped_Actual Completion Date] else[Target sample shipped] - [ISR Sample Shipped_Actual Completion Date])

Table.AddColumn(#"Changed column type 2", "New Column", each if [Custom] < 0 then "NO" else "YES")

Nhận xét