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

DAX formula Question

Hi, 

      I wrote this formular in Tableau, I try to  change it to PowerBI. But it keeps giving me error message. How can I translate this formular to powerBI. thank!goal.PNG

 

3 ACCEPTED SOLUTIONS

Accepted Solutions
Community Support
Community Support

Re: DAX formula Question

@smartbi123 ,

 

In dax, the syntax is different from tableau, e.g.: In dax, the if condition statement should be like below:

 

result = if(condition, result1, result2)

About other function and usage of dax, please refer to dax doc below:

 

https://docs.microsoft.com/en-us/dax/dax-function-reference

 

Community Support Team _ Jimmy Tao

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

View solution in original post

smartbi123 Helper I
Helper I

Re: DAX formula Question

figured out, need nested if statement. thanks!

View solution in original post

Highlighted
Super User II
Super User II

Re: DAX formula Question

It would also be a good idea to use variables, e.g.:

var __Quarter = ...

var __QTD = ...

var __QuarterGoal = SWITCH(__Quarter, "Q1", [Q1 Goal], "Q2", [Q2 Goal], etc.

return __QuarterGoal  * IF(__QTD < __QuarterGoal , -1,1)

 

Hope this helps,

Nathan

 

View solution in original post

3 REPLIES 3
Community Support
Community Support

Re: DAX formula Question

@smartbi123 ,

 

In dax, the syntax is different from tableau, e.g.: In dax, the if condition statement should be like below:

 

result = if(condition, result1, result2)

About other function and usage of dax, please refer to dax doc below:

 

https://docs.microsoft.com/en-us/dax/dax-function-reference

 

Community Support Team _ Jimmy Tao

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

View solution in original post

smartbi123 Helper I
Helper I

Re: DAX formula Question

figured out, need nested if statement. thanks!

View solution in original post

Highlighted
Super User II
Super User II

Re: DAX formula Question

It would also be a good idea to use variables, e.g.:

var __Quarter = ...

var __QTD = ...

var __QuarterGoal = SWITCH(__Quarter, "Q1", [Q1 Goal], "Q2", [Q2 Goal], etc.

return __QuarterGoal  * IF(__QTD < __QuarterGoal , -1,1)

 

Hope this helps,

Nathan

 

View solution in original post

Helpful resources

Announcements
New Ranks Launched March 24th!

New Ranks Launched March 24th!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power BI Community!

‘Better Together’ Contest Finalists Announced!

‘Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

Arun 'Triple A' Event Video, Q&A, and Slides

Arun 'Triple A' Event Video, Q&A, and Slides

Missed the Arun 'Triple A' event or want to revisit it? We've got you covered! Check out the video, Q&A, and slides now.

Top Solution Authors
Top Kudoed Authors