cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
mannsandhu963 Regular Visitor
Regular Visitor

Changing value of one field in respect to other in Power BI

Hi Experts,

 

I need to implement one logic as explained below.

I need to change the value for one field in respect to measure value in front of it. Like if measure value is <0 then the value of the field should show "NA" as shown.

 

- All values are coming from same table.

Table.PNGCurrent Table in Power Bi reportTable_AfterLogic.PNGTable should look like this after logic, I dont need to show Measure1 column also

 

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Changing value of one field in respect to other in Power BI

Hi @mannsandhu963,

 

What about creating a calcuted column with if function?

 

 

Column = IF('Table1'[Measure]<0,"NA",'Table1'[Column1])

if.PNG

 

 

Best Regards,

Cherry

Community Support Team _ Cherry Gao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 REPLIES 2
Community Support Team
Community Support Team

Re: Changing value of one field in respect to other in Power BI

Hi @mannsandhu963,

 

What about creating a calcuted column with if function?

 

 

Column = IF('Table1'[Measure]<0,"NA",'Table1'[Column1])

if.PNG

 

 

Best Regards,

Cherry

Community Support Team _ Cherry Gao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
mannsandhu963 Regular Visitor
Regular Visitor

Re: Changing value of one field in respect to other in Power BI

Thanks Cherry,

 

Can we achieve this using DAX through measures on the report only?

 

Regards,

mannsandhu963