topic Re: Calculate the date values in in DAX Commands and Tips

Calculate the date values in

Anonymous — Wed, 17 Nov 2021 08:14:26 GMT

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.

Re: Calculate the date values in

VahidDM — Wed, 17 Nov 2021 08:46:28 GMT

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/

Re: Calculate the date values in

Anonymous — Wed, 17 Nov 2021 09:09:00 GMT

VahidDM i want date single column sir. any idea

Re: Calculate the date values in

VahidDM — Wed, 17 Nov 2021 09:19:09 GMT

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/