create date column based on condition

[Anonymous]

Hi,

i have the following table

Create date             status

19-03-2019            Follow-up in 3 months

20-01-2019            badfit

21-03-2019            Follow-up in 1 month    

am having the status values like  follow_up in 1 month, 2 month, 3 month etc,

if status followup in 3 month then expected date need to come=[ createdate(3* 30days) ]

if status followup in 6 month then expected date need to come=[ createdate(6*30days) ]

i expect following  table

Create date             status                                     Expected date

19-03-2019            Follow-up in 3 months            19-05-2019

20-01-2019            badfit                                       

21-03-2019            Follow-up in 1 month              21-04-2019

[v-xicai · Accepted solution]

 Hi @Anonymous 

Firstly, create measures Follow_up Month to extract the month number, an then create measures Date1, Expected date to meet your demand.

Follow_up Month = VALUE(if((MID(SELECTEDVALUE(Table1[status]),14,1))="",0,MID(SELECTEDVALUE(Table1[status]),14,1)))

Date1 =

var d = max(Table1[Create date])

return DATE(YEAR(d),MONTH(d)+Table1[Follow_up Month],day(d))

Expected date = IF(SELECTEDVALUE(Table1[status])="badfit"," ",Table1[Date1])

Then, choose table visual to display the result.

 

Here is my test pbix: https://qiuyunus-my.sharepoint.com/:u:/g/personal/pbipro_qiuyunus_onmicrosoft_com/EXgLDtZ8H4pMr8r9kZOeXXIBAdViPGR3iOeCAM9XsnQYcg?e=KfbXay

Best Regards,

Amy

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.