Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
I have the table Like below
Proposed Date Delivery Date Saftey Actual Safetycover RiskType
13-11-2021 21-11-2021 2 3 urgentoverdue
14-11-2021 2 3 standardOverdue
16-11-2021 21-11-2021 2 3 oldoverdue
13-11-2021 21-11-2021 2 3 lack
14-11-2021 2 3 Advance
16-11-2021 21-11-2021 2 3 Requirements in past
i want add two colmn value based on the condions if Risktype contains overdue . values taken delivey date + safey actuals . if delivery date blank values taken a proposed delivery date.
if risk type not contain a ovedue like lack ,advance, Requirements in past . values taken delivery date+ safetycover.
. if delivery date blank values taken a proposed delivery date.
Solved! Go to Solution.
Hi @Anonymous
Try this:
Column 1 =
Var _A = CONTAINSSTRING([RiskType],"overdue")
Var _D = [Delivery Date ]
return
if(_A=TRUE(),
if(ISBLANK(_D),[Proposed Date],_D+2),
if(ISBLANK(_D),[Proposed Date],_D+[Safetycover]))
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
LinkedIn: www.linkedin.com/in/vahid-dm/
Hi @Anonymous
Try this:
Column 1 =
Var _A = CONTAINSSTRING([RiskType],"overdue")
Var _D = [Delivery Date ]
return
if(_A=TRUE(),
if(ISBLANK(_D),[Proposed Date],_D+2),
if(ISBLANK(_D),[Proposed Date],_D+[Safetycover]))
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
LinkedIn: www.linkedin.com/in/vahid-dm/
Hi @Anonymous
Try these codes:
Column 1 =
Var _A = CONTAINSSTRING([RiskType],"overdue")
Var _D = [Delivery Date ]
return
if(_A=TRUE(),
if(ISBLANK(_D),[Proposed Date],_D+2))
Column 2 =
Var _A = CONTAINSSTRING([RiskType],"overdue")
Var _D = [Delivery Date ]
return
if(_A=FALSE(),
if(ISBLANK(_D),[Proposed Date],_D+[Safetycover]))
Output:
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
LinkedIn: www.linkedin.com/in/vahid-dm/
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
24 | |
9 | |
7 | |
6 | |
6 |
User | Count |
---|---|
28 | |
11 | |
11 | |
10 | |
6 |