topic Re: Creating Column in DAX Commands and Tips

Creating Column

spandy34 — Tue, 08 Nov 2022 17:15:34 GMT

I want to create a column called 'Needs Action' where a 1 is inserted if Scheduled Date field has a date in it and the Actual Date field is blank. Can anyone tell me how I would do this please tamerj1 goncalogeraldes

Re: Creating Column

Greg_Deckler — Tue, 08 Nov 2022 17:25:25 GMT

spandy34 Try:

Column = IF( [ScheduledDate] <> BLANK() && [ActualDate] = BLANK(),"Needs Action",BLANK())

Re: Creating Column

spandy34 — Tue, 08 Nov 2022 18:54:47 GMT

Really appreciate your help . Thanks worked .