Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

MAXIF Custom Column

hi All,

I am able to created a calculated column for MAXIFS in power BI. However, I am not able to see the calculated column when editing query. (If I'm wrong about the ability to edit query for calculated column, let me know how can i do it. Thanks). Is there a way to created a MAXIFS using edit query-add custom column ? How should i write the formula to do that ? Any guidance is greatly appreciated.

 

Andrew

Need Help
  • v-yalanwu-msft's avatar
    v-yalanwu-msft
    3 years ago

    Hi, Anonymous ;

    If you create columns with DAX, you can't see them in Power Query, and if you create custom columns in Power Query, you can see them on desktop, which is by design. Depending on your formula, if you convert to Power Query, you can use Group By.

    Then expand it.

    The final result:


    Best Regards,
    Community Support Team _ Yalan Wu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    I have included the calculated column formula here;

    Latest Revision = Calculate(MAXA(ligechCdeaff[ind_devis]),FILTER(ligechCdeaff,ligechCdeaff[CdeAffaire.cod_affaire]=EARLIER(ligechCdeaff[CdeAffaire.cod_affaire]))).
    Any advise to convert this to custom column formula will be greatly appreciated
  • v-yalanwu-msft's avatar
    v-yalanwu-msft
    Community Support
    3 years ago

    Hi, Anonymous ;

    If you create columns with DAX, you can't see them in Power Query, and if you create custom columns in Power Query, you can see them on desktop, which is by design. Depending on your formula, if you convert to Power Query, you can use Group By.

    Then expand it.

    The final result:


    Best Regards,
    Community Support Team _ Yalan Wu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      Thanks for the advice. Let me explore the solution provided and see the outcome.