Order of operations

[lishapruthi]

What is the correct order of operation we use in Power BI for creating any report?

[v-xiaotang · Accepted solution]

Hi @lishapruthi 

In general, 

1. get your data

2. clear your data in PQ Editor if necessary,

3. Create and manage relationships

4. (1) Create calculated columns

    (2) Create your own measures

DAX tutorial : https://docs.microsoft.com/en-us/dax/

5. create visuals

Best Regards,

Community Support Team _Tang

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

[Greg_Deckler]

@lishapruthi 

1. Import or connect to data using Power Query Editor
2. Create relationships in your Model view of Power BI Desktop
3. Create any required DAX calculated columns and measures
4. In Report view, create visuals

Hopefully I understood the question correctly.