Forum Discussion

Yasser_Lababidi's avatar
Yasser_Lababidi
New Member
7 years ago
Solved

List of functions mapping Excel vs Power Query Editor

Hello,   I use Excel but I am new to Power BI. Does anyone have a list of "Functions Mapping" between Excel and Power Query Editor? For Example: "Search" Function in Excel is equivelant to "Text....
Tutorial Requests
  • Chihiro's avatar
    Chihiro
    7 years ago

    You should consider DAX completely separate from Excel formula/functions.

     

    DAX has more strict preference on what sort of data structure should be fed to it, when compared to Excel formula.

     

    I've seen too many people that struggled to grasp DAX and benefits of relationships when looking at it from Excel angle.

     

    Trust me, it will be easier to approach DAX as fresh new tool separate from Excel, even though it's made available in Excel's data model.

     

    It's much like learning another language; learning through translation will be more difficult, rather than diving in and learning language through experience. Some concepts doesn't translate very well between languages.

     

Yasser_Lababidi's avatar
Yasser_Lababidi
New Member
7 years ago

Greg_Deckler I don't need specific list right now. However, I need to google for every formula I need to use.

ImkeF I hope if you have such list?

 

Thanks

ImkeF's avatar
ImkeF
Community Champion
7 years ago

Unfortunately I don't have such a list.

The categories where you're most likely to find equivalent Excel-functions will be Text-, Number and Date(Time) functions. The other catagories don't have that many similarities to Excel functions.