Forum Discussion

mdrammeh's avatar
mdrammeh
Icon for Helper III rankHelper III
9 years ago
Solved

How to add a blank cell when formula returns error or null in Power Query

Hello,   I have two calculated columns with different expressions in Power Query. I want to calculate the difference between the two columns and return a blank value where the formula returns an er...
Need Help
Tutorial Requests
  • Datatouille's avatar
    Datatouille
    9 years ago

    Yes, I do suggest you use DAX measures in Power BI Desktop  (or Excel if you are using Excel with powerpivot).

     

mdrammeh's avatar
mdrammeh
Icon for Helper III rankHelper III
9 years ago

So are you suggesting I use DAX functions in Excel or Power BI instead of Power Query? Could you share an example from the Query editor? 

Datatouille's avatar
Datatouille
Icon for Solution Sage rankSolution Sage
9 years ago

Yes, I do suggest you use DAX measures in Power BI Desktop  (or Excel if you are using Excel with powerpivot).