cancel
Showing results for
Did you mean:
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!

3 ACCEPTED SOLUTIONS

Accepted Solutions
Highlighted
Community Support

## Re: DAX formula Question

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.

Helper I

## Re: DAX formula Question

figured out, need nested if statement. thanks!

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

3 REPLIES 3
Highlighted
Community Support

## Re: DAX formula Question

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.

Helper I

## Re: DAX formula Question

figured out, need nested if statement. thanks!

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

Announcements

#### 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!

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

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