Forum Discussion
Patv
Helper II
Helper IIHow to add where /Filter condition in DAX
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
