cancel
Showing results for
Did you mean:
Highlighted
Regular Visitor

## 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
Community Support Team

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

Regular Visitor

## 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
Community Support Team

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

Regular Visitor

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

#### Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

#### January 2020 Community Highlights

Make sure you didn't miss any of the things that happened in the community in January!

#### Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Top Solution Authors
Top Kudoed Authors