cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
admin_xlsior
Post Prodigy
Post Prodigy

Can IF statement follow by calculation?

Hi guys,

 

If I have this table

admin_xlsior_0-1612327420894.png

 

how to add custom column saying that If [Toggle] = 1 then [Value]/10 else [Value]/10 * -1

I found the If statement only allow a fixed value, is that correct? 

 

I'm sorry but I never use Power query or M language before.

 

Thanks.

 

 

1 ACCEPTED SOLUTION
Jimmy801
Super User III
Super User III

Hello @admin_xlsior 

 

what you mean by fixed value?

the first parameter you can use also a list or table by applying a function like

if Table.RowCount(YourTable)= 1 then ....

and for the then end else you can use let/in and functions as well like

if [Toggle]=1 then 
let 
   FirstStep = .....,
   SecondStep = FirstStep + 1
in
   SecondStep

else
   null



If this post helps or solves your problem, please mark it as solution (to help other users find useful content and to acknowledge the work of users that helped you)
Kudoes are nice too

Have fun

Jimmy

View solution in original post

2 REPLIES 2
Jimmy801
Super User III
Super User III

Hello @admin_xlsior 

 

what you mean by fixed value?

the first parameter you can use also a list or table by applying a function like

if Table.RowCount(YourTable)= 1 then ....

and for the then end else you can use let/in and functions as well like

if [Toggle]=1 then 
let 
   FirstStep = .....,
   SecondStep = FirstStep + 1
in
   SecondStep

else
   null



If this post helps or solves your problem, please mark it as solution (to help other users find useful content and to acknowledge the work of users that helped you)
Kudoes are nice too

Have fun

Jimmy

View solution in original post

hmm, yeah, I don;t know why it show error back then, but now is ok

admin_xlsior_0-1612335584787.png

Ok, thanks for comfirming.

 

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are You Ready?

Test your skills now with the Cloud Skills Challenge.

Top Solution Authors