How to add where /Filter condition in DAX

[Patv]

Hello Friends,  I am learning Dax so please excuse if I am asking question that has already been asked but I searched and couldn't find right solution. My questions is very simple.. 

I have a table  Called "Table1" ( attached here) that has ID, Task Name, seqNo columns. Now I want to add a new column  Let's called it "PAD Task Name" to that table, The condition is 

Add  three space at the beginning to "Task Name" column where seqNo not equal to 0 and don't make anychnage to if seqno = 0

I found out how to add space at the beginning  but DON'T KNOW HOW TO apply it to only rows where  seqNo not euqal to 0 

Text.PadStart([TASK_NAME],Text.Length([TASK_NAME])+3," ")

I want result just like in "PAD Task Name"column  shown in screen shot.

Your help will be appeciated here. Thank you.

-Vpat

[Vera_33 · Accepted solution]

Hi @Patv 

Use if statement

if [Seq No] =0 then [Task Name] else "    "&[Task Name]

[Patv]

Hi Vera_33, 

That's easy ! Thank you so much, it worked. Wondering why I could not think that.  Appreciate your reply. Thank you again!