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
Go to Solution.
Use if statement
if [Seq No] =0 then [Task Name] else " "&[Task Name]
View solution in original post
That's easy ! Thank you so much, it worked. Wondering why I could not think that. Appreciate your reply. Thank you again!
Click here to read more about the December 2021 Updates!
Mark your calendars and join us for our next Power BI Dev Camp!
Learn how to create your own user groups today!