Forum Discussion
Solved
increase date column based on conditions
Hi All, I am having some issues with how to approach my query so any help would be greatly appreciated. I have a date column that I need to increase based on two other columns values. e.g. Da...
PaulaL,
If you create a custom column in Power BI Desktop query editor, please use formula below.if [Impact] = "Urgent" and [LookUp] = "Stores" then Date.AddDays([DateReported],1) else if [Impact] = "Standard" and [LookUp] = "Floor" then Date.AddDays([DateReported],3) else null
If you create a calcualted column, please using DAX below.Column = if (and(SurveyCorrectiveAction[Impact] = "Urgent", SurveyCorrectiveAction[LookUp] = "Stores") ,SurveyCorrectiveAction[DateReported]+1 ,if(and(SurveyCorrectiveAction[Impact] = "Standard" , SurveyCorrectiveAction[LookUp] = "Floor" ), SurveyCorrectiveAction[DateReported]+3,BLANK()))
Regards,Lydia
PaulaL,
If you create a custom column in Power BI Desktop query editor, please use formula below.
if [Impact] = "Urgent" and [LookUp] = "Stores" then Date.AddDays([DateReported],1) else if [Impact] = "Standard" and [LookUp] = "Floor" then Date.AddDays([DateReported],3) else null
If you create a calcualted column, please using DAX below.
Column = if (and(SurveyCorrectiveAction[Impact] = "Urgent", SurveyCorrectiveAction[LookUp] = "Stores") ,SurveyCorrectiveAction[DateReported]+1 ,if(and(SurveyCorrectiveAction[Impact] = "Standard" , SurveyCorrectiveAction[LookUp] = "Floor" ), SurveyCorrectiveAction[DateReported]+3,BLANK()))
Regards,
Lydia
