I am very new to Power Bi. I am pulling a csv file and I started the transform data. I can add the custom columns , but the formula language is confusing. I figured out an easy one using the IF , then, and else. I am having trouble adding the following formulas. I am hoping someone can help with this.
=IF(AND([Activity Type]="Start Milestone",[Planned Finish]=""),$[Planned Start],IF(AND([Activity Type]="Finish Milestone",[Planned Start]=""),[Planned Finish],""))
=IF([Activity Type]<>"Not Started",MAX([Actual Start]:[Actual Finish]),"")
This last one is a little different because sometimes milestones get added and both dates are blank. On excel it gives me the 1/0/00 date
=IF(AND([Activity Start]="Start Milestone",[BL Project Finish]=""),[BL Project Start],IF(AND([Activity Start]="Finish Milestone",[BL Project Start]=""),[BL Project Finish],""))
IF anyone could help with this it would be greatly appreciated.
=IF(AND([Activity Type]="Start Milestone",[Planned Finish]=""),$[Planned Start],IF(AND([Activity Type]="Finish Milestone",[Planned Start]=""),[Planned Finish],""))
=IF([Activity Type]<>"Not Started",MAX([Actual Start]:[Actual Finish]),"")
This last one is a little different because sometimes milestones get added and both dates are blank. On excel it gives me the 1/0/00 date
=IF(AND([Activity Start]="Start Milestone",[BL Project Finish]=""),[BL Project Start],IF(AND([Activity Start]="Finish Milestone",[BL Project Start]=""),[BL Project Finish],""))
IF anyone could help with this it would be greatly appreciated.
