cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Patv
Helper I
Helper I

How 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.
Excel.png
Your help will be appeciated here. Thank you.
-Vpat
1 ACCEPTED SOLUTION
Vera_33
Super User
Super User

Hi @Patv 

 

Use if statement

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

View solution in original post

2 REPLIES 2
Vera_33
Super User
Super User

Hi @Patv 

 

Use if statement

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

View solution in original post

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!

Helpful resources

Announcements
Power BI December 2021 Update_carousel 768x460.jpg

Check it Out!

Click here to read more about the December 2021 Updates!

Jan 2022 Dev Camp 768x460 copy.png

Power BI Dev Camp- January 27th, 2022

Mark your calendars and join us for our next Power BI Dev Camp!

UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Top Solution Authors