Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
nisha_deepak
Helper III
Helper III

condition based on on column

i have report which contains one number field....values are like -120,-131,-12,-1,0,1,2,3,30,32,34,60,61,62,87,90,91 etc.

I need another column based on some conditions apply with above mentioned column.The condition i want is if value -120 or -131 or any negative value means that all are mentioned like" nothing" ,if value is o means show as "expired " and if value is from range 1-30 means "30 days" ,if value is 31-60 means "60 days" ,if value is 61-90 means "90 days" like that i want show in new column.Plse

help me.here am attaching sample report i wantCapture.PNG

 

2 REPLIES 2
v-jingzhang
Community Support
Community Support

Hi @nisha_deepak 

You can also add a column in Power Query Editor by Add column -> Conditional Column.

10304.jpg

Best Regards,

Community Support Team _ Jing Zhang

If this post helps, please consider Accept it as the solution to help other members find it.

tex628
Community Champion
Community Champion

Try a calculated one with the following:

Column = 
IF( [Value] = 0 , "Expired",
IF( [Value] < 0 , "Nothing",
IF( [Value] < 31 , "30 Days",
IF( [Value] < 61 , "60 Days", 
IF( [Value] < 91 , "90 Days",
"Over 90"


Let me know how it goes! 🙂

Br
J


Connect on LinkedIn

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.