Convert excel Formula to Dax in Power BI

[Allan-Mautante]

Im new in Power Bi Just need Need help on converting this excel formula to Power BI:

Thank you in advance!!

[v-yangliu-msft]

Hi  @Allan-Mautante ,

Excuse me, what is the expected effect you need to achieve, what is the logic of the realization, we better help you to complete it with Dax

Best Regards,

Liu Yang

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

[lbendlin]

It is generally not advisable to attempt to re-implement Excel formulas in Power BI (although Greg Deckler has a series of articles about that).

Please provide sample data in usable format (not as a picture) , explain the business problem, and show the expected outcome.