cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Frequent Visitor

## How to convert Tableau calculation to Power BI?

Hello,

I am very new to Power BI. My company is looking into option of transitioning to Power BI from Tableau.

My question is how do I convert Tableau Calculation to Power BI?

For eg:

DATE({FIXED [Order Number]: MIN(IF [Customer ID]='0510'
THEN [Order Date Time]
END )})

1 ACCEPTED SOLUTION
Super User

Try something like:
Measure = CALCULATE(MIN(Table[Order Date Time]), Table[Customer ID]="0510", ALLEXCEPT(Table[Order Number]))

If you've already got the table grouped by Order Number, then you should be able to skip the last CALCULATE argument.

Here's the docs for the above functions:
https://learn.microsoft.com/en-us/dax/allexcept-function-dax

https://learn.microsoft.com/en-us/dax/calculate-function-dax

and I also recommend giving this a read - https://www.sqlbi.com/articles/introducing-calculate-in-dax/ as it helped me a lot when I transitioned from Tableau to PowerBI.

2 REPLIES 2
Frequent Visitor

Thank you @vicky_ for the solution and for the links. They seem to be very good source. Really appreciate it 🙂

Super User

Try something like:
Measure = CALCULATE(MIN(Table[Order Date Time]), Table[Customer ID]="0510", ALLEXCEPT(Table[Order Number]))

If you've already got the table grouped by Order Number, then you should be able to skip the last CALCULATE argument.

Here's the docs for the above functions:
https://learn.microsoft.com/en-us/dax/allexcept-function-dax

https://learn.microsoft.com/en-us/dax/calculate-function-dax

and I also recommend giving this a read - https://www.sqlbi.com/articles/introducing-calculate-in-dax/ as it helped me a lot when I transitioned from Tableau to PowerBI.

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

#### Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

#### Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors
Top Kudoed Authors