Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

RECREATE EXCEL FORMULA

I need to recreate an excel formula in power bi and make this a new column, but not with DAX, if I'm not mistaken I need to do it with the M language, but I don't know how to do it THIS IS MY FORMUL...
Need Help
  • BA_Pete's avatar
    BA_Pete
    2 years ago

    Hi Anonymous ,

     

    There's a number of syntax issues with your M code.

    Assuming that your [#"FECHA"] column is a Date data type, try something like this instead:

     

    if [PORT.CARRIER DESC] = "SomeName" and [#"FECHA"] <= #date(2024, 01, 02) then "REN"
else "ACT"

     

     

    Pete

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
2 years ago

While you can create calculated columns with DAX it is indeed recommended to instead implement these in Power Query whenever possible.

 

Can you formulate the business requirement behind your Excel formula?  Converting from Excel to Power BI is often an exercise in futility (although Greg Deckler has a thread here that lists all the equivalents)

 

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).

Do not include sensitive information or anything not related to the issue or question.

If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216

Please show the expected outcome based on the sample data you provided.

Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523